Excel 2007 : Random number generator without repeats

I am currently using this formula for random drug screening; however, it often repeats a number. For simplicity here, lets say I have 10 names in a column on the left with a header row.
I would use:
=RAND()*(11-1)+1 where 11 is the last row number with a name populated. I would then have the spreadsheet set up this way:
Column 1 numbers 1 through however many employees I have; Column 2 employee names; column 3 formula in cell C1. I would drag C1's formula through how ever many rows I want employees selected for. If I want 50% chosen randomly to test I drag through 5 rows. It generates 5 numbers I match to the name next to that number generated. EXCEPT: it will repeat numbers already selected. How do I make it not repeat an already chosen number?
Thanks,
Jim, HR Director

Originally Posted by shg

In an convenient column, =RAND()

Then sort by that column and pick the top N names from the list.

I tried that and it did not work for me. Hmmm, I must be missing something. It only gave me zeros and ones. Machine language, LOL

check this out
http://www.excelforum.com/excel-gene...o-repeats.html