| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Numbers
I would like to create 30 random numbers in cells A1 to A30 that are between
1 and 2000, and I do not want duplicates. For example, I don't want cells A5 and A22 to return 1752. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Random Numbers
http://www.tushar-mehta.com/excel/ne...ion/index.html
-- Kind regards, Niek Otten "Terence" wrote in message ... I would like to create 30 random numbers in cells A1 to A30 that are between 1 and 2000, and I do not want duplicates. For example, I don't want cells A5 and A22 to return 1752. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you assign random numbers to many different lines of row? | Excel Worksheet Functions | |||
| random numbers | Excel Worksheet Functions | |||
| Random Numbers | Excel Discussion (Misc queries) | |||
| random numbers from a data of numbers? | Excel Worksheet Functions | |||
| Random Assignment of Numbers | Excel Worksheet Functions | |||
Hybrid Mode
