Randbetween on a list of names

[jimbojames136]

i have a list of names in column A2:A12 i have a formula that randomly picks from these names to poupulate a list in B2:B6 and C2:C6.

but i cannot seem to find a way of stoping the Randbtween formula duplicating results.

 

Is there a way to stop duplicates ?

 

 

thanks

James

[clareq]

Book1.xlsxTry this - I've generated random numbers between 1 and 10000, ranked them, then used vlookup to return the name in that position on the list - it makes more sense when you look at it! Edited June 15, 2012 by clareq
I can't spel