| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assigning random numbers without repetition
hi
I want to assign random numbers from 1 to 50 to the range of A1:A20 without repetition.I checked several related questions but really couln`t understand how this works. thanks for help. -- Regards, Baha |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assigning random numbers without repetition
I like J.E. McGimpsey's UDF.
You can find it he http://www.mcgimpsey.com/excel/udfs/randint.html Baha wrote: hi I want to assign random numbers from 1 to 50 to the range of A1:A20 without repetition.I checked several related questions but really couln`t understand how this works. thanks for help. -- Regards, Baha -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-Assigning a (random) Name from list of values | Excel Discussion (Misc queries) | |||
| Random number with no repetition? | Excel Discussion (Misc queries) | |||
| Assigning a value to a set of numbers | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Hybrid Mode
