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
|