Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fomula
Can anyone help with this?
I wish to use say 16 numbers in groups of 4 on 5 seperate occasions and not have the same number apear twice with any other numer used previously? Is this able to be done or am I expecting too much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fomula
Hmmm... 5 groups of 4 numbers out of 16 without duplication isn't
possible (you'd need at least 20). You might find one of the techniques here helpful: http://mcgimpsey.com/excel/udfs/randint.html In article , xpert 1 <xpert wrote: Can anyone help with this? I wish to use say 16 numbers in groups of 4 on 5 seperate occasions and not have the same number apear twice with any other numer used previously? Is this able to be done or am I expecting too much! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fomula
Thanks JE McGimpsey, that sort of helps but it still is useing the same
number more than once. Where I am trying to use this is in the form of a golf trip with 16 players playing in groups of 4 over 5 days, so as not to have anyone of the 4 in the group playing with someone they have already played with over the 5 days of golf, that is so everybody plays with someone once only? -- Thanks from down under!! "xpert 1" wrote: Can anyone help with this? I wish to use say 16 numbers in groups of 4 on 5 seperate occasions and not have the same number apear twice with any other numer used previously? Is this able to be done or am I expecting too much! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fomula
I really don't know any formulaic way to do this in XL.
In article , xpert 1 wrote: Thanks JE McGimpsey, that sort of helps but it still is useing the same number more than once. Where I am trying to use this is in the form of a golf trip with 16 players playing in groups of 4 over 5 days, so as not to have anyone of the 4 in the group playing with someone they have already played with over the 5 days of golf, that is so everybody plays with someone once only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fomula (if?) | Excel Worksheet Functions | |||
Fomula | Excel Discussion (Misc queries) | |||
Please help, i need a fomula | Excel Worksheet Functions | |||
IF Fomula | Excel Discussion (Misc queries) | |||
Scurve fomula in Excel | Excel Worksheet Functions |