formula to select numbers from a range

M

mark (plymouth)

I am trying to create a formula which would select 6 unique numbers from a
range between 1 and 24 and list trhem into a cell.
Can anyone help please?
 
G

Gary''s Student

Do it in two steps:


In A1 thru A24 enter 1 thru 24
In B1 thru B24 enter RAND()

Sort the columns by column B (this will shuffle the data in column A)

In C1 enter
=A1 & A2 & A3 & A4 & A5 & A6
This will pick up a randon, unique set of numbers.
 
Top