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

  • Thread starter Thread starter gmadden2
  • Start date Start date
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?
 
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.
 
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.
 

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

How do I randomly select cells regardless of cell content? 3
random cell selection from a column of cells 2
Random Whole Number Functions 3
Select multiple adjacent cells of multiple cells without selecting 7
selecting an item at random for QA sampling 1
Random Sort selected cells 1
'Flash' random numbers 6
MACRO RUN random percentage and copy of column values 1

Back
Top