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 ?
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!
Last edited by clareq; 15th June 2012 at 03:28 PM. Reason: I can't spel
There are currently 1 users browsing this thread. (0 members and 1 guests)