| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding, multiple datasets to include all combinations
I have 40 observed travel times for A to B, 50 for B to C and 25 for C to D.
Is there a way in Excel to calculate a list of all the possible total travel times from A to D? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding, multiple datasets to include all combinations
This will give you 40 x 50 x 25 different combinations. Are you sure
you want a list 50,000 items? If so, give me some details of how your data is laid out. I did something similar last week for a poster, and if your data is something like this: A_B B_C C_D time time time time time time (to 40) (to 50) (to 25) then I can adapt it for you to go into column D - one formula copied down. Hope this helps. Pete On Feb 3, 11:15*pm, K wrote: I have 40 observed travel times for A to B, 50 for B to C and 25 for C to D. * Is there a way in Excel to calculate a list of all the possible total travel times from A to D? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding, multiple datasets to include all combinations
Yes exactly that format and yes I know it's unfortunately 50000!
Thanks in advance "Pete_UK" wrote: This will give you 40 x 50 x 25 different combinations. Are you sure you want a list 50,000 items? If so, give me some details of how your data is laid out. I did something similar last week for a poster, and if your data is something like this: A_B B_C C_D time time time time time time (to 40) (to 50) (to 25) then I can adapt it for you to go into column D - one formula copied down. Hope this helps. Pete On Feb 3, 11:15 pm, K wrote: I have 40 observed travel times for A to B, 50 for B to C and 25 for C to D. Is there a way in Excel to calculate a list of all the possible total travel times from A to D? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding, multiple datasets to include all combinations
Okay, put this formula in D1:
=INDIRECT("A"&MOD(INT((ROW(A1)-1)/(COUNTA(B:B)*COUNTA(C:C))),COUNTA (A:A))+1)+INDIRECT("B"&MOD(INT((ROW(A1)-1)/COUNTA(C:C)),COUNTA(B:B)) +1)+INDIRECT("C"&MOD(ROW(A1)-1,COUNTA(C:C))+1) and copy it down. This assumes that you have no headers, so that your data begins in row 1. Hope this helps. Pete On Feb 4, 6:14*am, K wrote: Yes exactly that format and yes I know it's unfortunately 50000! Thanks in advance "Pete_UK" wrote: This will give you 40 x 50 x 25 different combinations. Are you sure you want a list 50,000 items? If so, give me some details of how your data is laid out. I did something similar last week for a poster, and if your data is something like this: * A_B * * *B_C * * * C_D * time * * *time * * * time * time * * *time * * * time (to 40) * *(to 50) * *(to 25) then I can adapt it for you to go into column D - one formula copied down. Hope this helps. Pete On Feb 3, 11:15 pm, K wrote: I have 40 observed travel times for A to B, 50 for B to C and 25 for C to D. * Is there a way in Excel to calculate a list of all the possible total travel times from A to D? Thanks.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookups with multiple possible combinations | Excel Worksheet Functions | |||
| get a value from multiple criteria combinations | Excel Worksheet Functions | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| Adding up cells that include text in them | Excel Discussion (Misc queries) | |||
Linear Mode
