Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. -- Gary''s Student "mark (plymouth)" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Range of numbers in a formula...PLEASE HELP!!! | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |