Generating a random movie of genre X

[colloidchemist]

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

 

[merjet]

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

 

[colloidchemist]

Ahh it's so simple. Thank you.