=Rand( )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, I can write simple functions. but I need help with this one

I would like Excel to generate a random number between 1 and 30. No problem I can do that

But... I don't want it to pick that number again. Each number could only be picked 1 time

I am using Excel to randomly pick student computer numbers to present their projects to class

Anyone able to do that

Thanks As Always
RIP
 
Hi

You can't do this in a simple way without using a list of contestants in a
range of spreadsheet cells.

Enter numbers 1 to 30 in range A1:A30. Enter =RAND() in range B1:B30. Click
F9 and sort by B column (Sort is in the Data menu or in a toolbar, the A-Z
button). Top X in A column are the winners/loosers/whatever.

HTH. Best wishes Harald
 
Hi Rip,

Put 1 to 30 in column A. In column B =RAND() and fill down.

Now sort A & B using B as the sort column. Use the number in A1 as the
"pick number" and delete the values in A1 & B1 after picking.

Select the remaining numbers including A1 & B1, resort using B1 as
activecell and you have a new "pick" in A1.

HTH
Regards,
Howard
 
Back
Top