Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random numbers
I'm running a macro which(using a For Loop), inputs the results from certain
calculations into a row and then carries out the same process entering the data into the next row for 100 rows. The calculations involve using a random number which has been generated in a different cell. I need a different random number to be generated each time the calculations are done. At the moment the random number is the same for each row. Any advice on how to amend this without having to creat a list o f 100 random numbers? Many Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I generate random, non-repeating numbers that don't change? | Excel Discussion (Misc queries) | |||
Random Numbers | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Random Assignment of Numbers | Excel Worksheet Functions | |||
Random list (1-45) without repeating numbers? | Excel Worksheet Functions |