Duplicate ramdom sampling
 

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 are duplicated. Could you please tell me if this doesnot happen. All i have are two columns. One has employee I.D. No. and the other has their name right next to it.

Thank you.

Duplicate ramdom sampling
 

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 D1:D25 and array-enter
=index(A1:A100,C1:C25)
etc.

Regards,
Bernd

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