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
Bookmarks