what can I do to randomly select cells that contain text?

G

gmadden2

I have a spreadsheet of text cells ... I wish to randomly select a specified
number of cells from a specified column ... what must I do to accomplish that
random selection?
 
S

Sean Timmons

assuming column A is your specified column:

=INDIRECT("A"&ROUND(RAND()*500+1,0)

This assumes you have 500 cells with values in them.

Copy and paste this formula the specified number of times, and you will get
the values in those random cells. Every time you edit any cell, the values
will change.
 
G

Glenn

Including duplicates, which may not be desirable.

If your text values are in A1:A100, put =RAND() in B1:B100 and then in C1:C100
put the following:

=INDEX($A$1:$A$100,RANK(B1,$B$1:$B$100))

Copy the number of values desired from column C.
 
Top