shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
Hi,
I have a list of 65 dates which I am trying to show all the combinations of but in time order. They are in column A from Row 7 down.
Small example of what I want (only 4 dates in this one)
List
01/Jan/2011
01/Feb/2011
01/Mar/2011
01/Apr/2011
The result I want (From row 7 down in column B, each line in same cell).
01/Jan/2011 - 01/Feb/2011
01/Jan/2011 - 01/Mar/2011
01/Jan/2011 - 01/Apr/2011
01/Feb/2011 - 01/Mar/2011
01/Feb/2011 - 01/Apr/2011
01/Mar/2011 - 01/Apr/2011
How could I do that? Any ideas other than sitting and linking all the cells with =a7&a8 then =a7&a9 and so on.
I have a list of 65 dates which I am trying to show all the combinations of but in time order. They are in column A from Row 7 down.
Small example of what I want (only 4 dates in this one)
List
01/Jan/2011
01/Feb/2011
01/Mar/2011
01/Apr/2011
The result I want (From row 7 down in column B, each line in same cell).
01/Jan/2011 - 01/Feb/2011
01/Jan/2011 - 01/Mar/2011
01/Jan/2011 - 01/Apr/2011
01/Feb/2011 - 01/Mar/2011
01/Feb/2011 - 01/Apr/2011
01/Mar/2011 - 01/Apr/2011
How could I do that? Any ideas other than sitting and linking all the cells with =a7&a8 then =a7&a9 and so on.
