Hi
in B1 put
=RAND()
copy this down for all rows
Now sort with column B and pick from column A the number of required
IDs.
With resorting you get a new sample

--
Regards
Frank Kabel
Frankfurt, Germany


topkick wrote:
I have a column of employee id's that have alpha numeric characters I
need to pull a random sampling for a drug test how do I do it? I
tryed rand() and Randbetween and no luck making that work.