Duplicate ramdom sampling

  • Thread starter Thread starter Lee Mathew
  • Start date Start date
L

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
 
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
 
Back
Top