I have a spreadsheet created in OpenOffice (V3.3.0 in Windows 7 32 bit) that I use as a database of my DVD collection. After asking a question in SuperUser, I have it so it can pop up a random title from my collection for the times I can’t make up my mind what to watch. It uses the following formula:
This selects a random value between the start and end of my DVD’s and displays the name. This works fine but I now want to expand on it to make it a bit more sophisticated.
Every time I watch a DVD, I mark down the date in a column in the spreadsheet. I now want the random selection to pick one that I haven’t seen in, say, the last six months.
I may expand on this in the future to, for example, select a random one that I haven’t seen in the last 6 months AND is a comedy (I also have a column of the film’s genre).
Any pointers on how to do this will be gratefully received.