Home |
Search |
Today's Posts |
#3
|
|||
|
|||
Hello Gary From Steved
Can your formula devoloped to display 6 columns across and 10 rows deep please. Thankyou. "Gary''s Student" wrote: If you need to randomly select 6 numbers from the range 1-40 with no repeats: 1. Enter the numbers 1-40 into an un-used column 2. Enter =RAND() into the cells of the adjacent column 3. Sort the two columns by the RAND column This will jumble the numbers 1-40 randomly. Just pick the first six numbers. -- Gary''s Student "Steved" wrote: Hello from Steved ok I am no thinking straight What do I need to do please to have a number in a row 1 to 40 as an example below 1,23,9,25,33,40 each row needs to be 1 to 40 but number no more than once six rows deep yes the other rows can have the same numbers as above or below =INDEX(ROW($A$1:$F$10),RANK($H1,$H$1:$H$60)) =RAND() copied H1:H60 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions |