Duplicate ramdom sampling

[Lee Mathew]

Hi,

I am trying to make a sample of 25 from 100 employees using Excel 2003
But everytime i do a sample, there are two or three employees that ar
duplicated. Could you please tell me if this doesnot happen. All i hav
are two columns. One has employee I.D. No. and the other has their nam
right next to it.

Thank you

 

[Bernd P]

Hello Lee,

Put my UDF uniqrandint into a macro module:
http://www.sulprobil.com/html/uniqrandint.html

If your data is in A1:B100, select C1:C25 and array-enter
=uniqrandint(100)
Select D125 and array-enter
=index(A1:A100,C1:C25)
etc.

Regards,
Bernd

 

[Lee Mathew]

Hello Bernd,

Thank you for responding to my question. But I think that i phrased the
question wrong. I have a list of 100 employees, some of whom are
part-time employees. All i have are two columns. One has employee I.D.
No. and the other has their name right next to it. I created a pivot
table of only the partially active employees. Now, the employee I.D.
numbers are not consecutive numbers. I need to make a sample of these
partially active employees; without duplicating them.

Thank you,

Lee