Ramdom selection with criteria

S

starky

I am trying to select 15 random numbers from a list of 65 (A1:A65), I also
only want numbers that match a set criteria (B1:b65 = x). Is that possible?
 
G

Gary''s Student

Assuming that column B contains either "x" or is blank:

In column C enter:

=RAND()

First sort by column B to put all the x's together and then sort by column
C. The pull the top 15 items from column A
 
S

starky

In Column B is a list of 10 group names, I need to be able to pull 15 from
group 3 group 6, and group 10. The 65 for the entire group may have varying
amounts for each of the 10 groups.
 
Top