choosing random entries

  • Thread starter Thread starter tclohesy
  • Start date Start date
T

tclohesy

I have a list of about 50 items, and I want to be able to choose, and
separately list, x number of them. This number may change, so I might
want all of them, or just 20. I want them to be randomly chosen each
time. Is there a way of doing this. I thought I had seen a post
similar a while back, but can't remember where...

Cheers,

Tony
 
enter this in cell F2 (for example);
=rand()<.4
which is 40% or 20 items of 50 items.
Use Data/Filter/Advanced filter, and for criteria reference F1:F2 (F1 is
blank)

Bob Umlas
Excel MVP
 
Back
Top