Office Software Thread, Randbetween on a list of names in Technical; i have a list of names in column A2:A12 i have a formula that randomly picks from these names to ...
23rd May 2012, 09:23 AM #1
Randbetween on a list of names
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 ?
IDG Tech News
15th June 2012, 02:28 PM #2
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 02:28 PM.
Reason: I can't spel
Last Post: 3rd October 2010, 06:35 PM
By gwendes in forum Gaming
Last Post: 30th April 2010, 08:45 AM
By sLiDeR in forum Windows
Last Post: 4th December 2007, 12:40 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)