Ramdom selection with criteria

  • Thread starter Thread starter starky
  • Start date Start date
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?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE! error nesting IF function 5
Multi-demensional frequency distribution 4
Excel Need Countifs Formula Help 0
Set range with Find method 1
Access Dcount (multiple criteria) 3
sum multiple columns with SUMIF or SUMPRODUCT 2
How do I get ONLY new info from 1 Worksheet to another automatical 6
Select A Random Cell From A Defined Range No Dups 2

Back
Top