Ramdom selection with criteria
 

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?

Ramdom selection with criteria
 

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
--
Gary''s Student - gsnu200779


"starky" wrote:

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?

Ramdom selection with criteria
 

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200779


"starky" wrote:

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?