Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating random numbers | Excel Worksheet Functions | |||
Generating Random numbers. | Excel Discussion (Misc queries) | |||
generating a whole random # from a list | Excel Programming | |||
AWESOME MOVIE! << I found this movie link in an AOL chatroom. It is based on real evidence and I give it a big thumbs-up. | Excel Programming |