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.

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