MrExcel Publishing
Your One Stop for Excel Tips & Solutions

assign number randomly?


Posted by Rick on January 21, 2002 11:23 AM

Is there a way to assign a number (a known account number) randomly to one of six workers? and store the numbers assigned to each person in a database type format or list?


Posted by Chris D on January 21, 2002 1:35 PM

Hi Rick,

could you use VLOOKUP in conjunction with RAND ?

table your account numbers (say there's 20 of them) with a number 1 to 20 next them

then get rand to generate a random number between 1 and 20, using VLOOKUP to return the account number corrosponding to the random number

I'm sure there's an easier way, but this should get you started !

Chris