Randomize List For Competition Draw

I'm running a Secret Santa DJ competition this year and today now wish to make the draw.

Basically all entrants send in their mixes (in this case - upload to a webserver) and I then wish to try and use Excel to make the draw.

What I'd like to do is have a list of all the entrants in column a, use RAND() in column b to assign them each a number, and in column c use the list of entrants in column a to assign each person a mix to receive.

Through my browsing and searching on here, I came across the following (entered as an array); it's brilliant but unfortunately gives me duplications.


=INDEX($A$1:$A$10,COUNTA(A:A)-SUM((B1>$B$1:$B$10)+0))