MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Kris on October 22, 2001 4:41 AM


I am trying to solve the following problem: I have a list of 75 exam candidates who take an exam every week. For confidentiality purposes, I would like to assign each one of them a different random number (between 1-75) every week. Clearly, the number assigned to each candidate should be different each week. How can I set this up in Excel?

Many thanks,

Posted by Aladin Akyurek on October 22, 2001 5:22 AM

In A1 enter: =RAND()

Copy down this to A2:A75.

In B1 enter: =RANK(A1,$A$1:$A$75)

Copy down this B2:B75.

You can copy the range B1:B75 and do a Paste Special|Values in a different location. This gives you the first series. The second time you need another series, just activate B2 and give enter.