Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Number Formulas
It's easy to generate a random number between 1 and 20 (in this example)
with "=randbetween(1,20)" . However, with this formula a number may be duplicated. How can a random number be generated so that no number is repeated ? In other words, how do I enter the formula to create unique random numbers between 1 and 20 ? Thanks ! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Number Formulas
Sounds like you want to shuffle 20 numbers
In column A, enter 1 to 20 in column B put in the formula =rand() then select A1:B20 and sort on column B. -- Regards, Tom Ogilvy "carlstedt" wrote in message ... It's easy to generate a random number between 1 and 20 (in this example) with "=randbetween(1,20)" . However, with this formula a number may be duplicated. How can a random number be generated so that no number is repeated ? In other words, how do I enter the formula to create unique random numbers between 1 and 20 ? Thanks ! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
same number appears in a random number generator | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) |