Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I create a random order within a series of numbers in Excel?
My project involves a random draw for starting order for a sports event. I
want to assign a randon number to entry forms, based on a series of numbers from 1 to 30. I am using EXcel 2003, but have little experience with anything but the simplest formulas. Can anyone help me? |
#2
|
|||
|
|||
Can I create a random order within a series of numbers in Excel?
OK...
Column A has your list of numbers 1-to-30. Next to each one in column B has the formula =rand() C1 has the formula =RANK(B1,$B$1:$B$30) Fill the forumula down to cell C30 Hide column B to make it tidy, and column C holds a random number 1-to-30 without duplicating. Remember, everytime you re-calculate the sheet the random numbers will change and give you a new combination so it might be worth printing it or something each time you use it. "Dimtrax" wrote: My project involves a random draw for starting order for a sports event. I want to assign a randon number to entry forms, based on a series of numbers from 1 to 30. I am using EXcel 2003, but have little experience with anything but the simplest formulas. Can anyone help me? |
#3
|
|||
|
|||
Can I create a random order within a series of numbers in Exce
This was so simple. With 150 events, this will save me an hour of time and
effort. Thank you. "Widemonk" wrote: OK... Column A has your list of numbers 1-to-30. Next to each one in column B has the formula =rand() C1 has the formula =RANK(B1,$B$1:$B$30) Fill the forumula down to cell C30 Hide column B to make it tidy, and column C holds a random number 1-to-30 without duplicating. Remember, everytime you re-calculate the sheet the random numbers will change and give you a new combination so it might be worth printing it or something each time you use it. "Dimtrax" wrote: My project involves a random draw for starting order for a sports event. I want to assign a randon number to entry forms, based on a series of numbers from 1 to 30. I am using EXcel 2003, but have little experience with anything but the simplest formulas. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Can excel be used to create a random number generator? | Excel Discussion (Misc queries) | |||
EXCEL, I want to create a series of calendars with dates marked f. | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |