random

  • Thread starter Thread starter sj
  • Start date Start date
S

sj

I am trying to set up a worksheet to randomly sellect a
certain percentage of itmes from a list. I need to slect
text data, and I need to be able to change the number of
fields of text(over time) to pull the same percentage of
text fields. All this and I don't want the same fields
sellected every time.

Can Anyone help?
 
If you want 25% of the records, for example, then enter =RAND()<.25 in row 2
in G2, for example (G1 being blank) (find an approprpiate place)
Select a cell in your data, use Data/Filter/Advanced filter, click in
Criteria and select G1:G2. You will get approximately 25% random selection.
If you want another percentage, simply change it in cell G2.
 
Back
Top