One way:
If your values are in A1:A100, enter =RAND() in B1 and copy down to
B100. Select a cell in column B and choose Data/Sort, sorting on column
B. Take the first N alphanumerics in column A, where N is the number of
samples.
Alternatively, to do it without sorting:
If you enter the RandInt User Defined Function found he
http://www.mcgimpsey.com/excel/randint.html
If your alphanumerics are in A1:A100, then to pull 15 samples, select
B1:B15 and array-enter
=INDEX(A:A,RandInt(1,100))
In article ,
"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.