Creating a table with formulas...

[Redrazorneck1]

I need to set up a table that uses one column of data (column A). The data consists of location codes, and the table headers will be "ship-from" and "ship-to". My task is to get the one column of data into the table so that each possible scenario is captured. If I have 50 locations, I'll have 50x49 (you can't ship to yourself) possibilities, or 2,450 combinations . Here's a small example of what I'm trying to do:

Column A
1
2
3


Ship From / Ship To
1 / 2
1 / 3
2 / 1
2 / 3
3 / 1
3 / 2

Is there a quick way to get this done? Thanks!

 

[TheNoocH]

It ran for about 5 minutes - and it worked beautifully. The total rows created matched up perfectly with the calculated amount (371 x 370).

CHEERS!

RRN

great...i PM'd Jindon last night for a quicker solution...he said his took about 14 seconds (not bad compared to the 5 mins for mine)...he knows this stuff inside and out and i'm continually learning...that was the main reason i asked if you needed to run it just once or multiple times....glad mine worked though even if it was slow...