Generating a random movie of genre X
Hey,
I have a list of all the movies I own, and what genre they are. Being indecisive, I decided to create a "random movie generator" that spits out 10 random movies in my list. However, it would be great if I could limit this to a particular genre as my fancy suits me. What I'm looking to be able to do is to type into a cell a genre, say "Action", and have the spreadsheet give me a random action movie that is in my list. Anyone have an idea how to do it? Any help would be great. Thanks. Tom |
Generating a random movie of genre X
Suppose the movie titles are in column A and the genres are in column
B, starting in row 2. In column C put =RAND() in each row. Auto-filter columns A & B, selecting which genre you want. Then sort all 3 columns together, sorting only by column C. Use the first 10 visible rows as your selections. Hth, Merjet |
Generating a random movie of genre X
Ahh it's so simple. Thank you.
On May 17, 9:24 pm, merjet wrote: Suppose the movie titles are in column A and the genres are in column B, starting in row 2. In column C put =RAND() in each row. Auto-filter columns A & B, selecting whichgenreyou want. Then sort all 3 columns together, sorting only by column C. Use the first 10 visible rows as your selections. Hth, Merjet |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com