Permutation list help needed...totally lost

[hyprlteman]

So...first post...You guy are all Excel masters I have to say.. I figured that this might be my best shot to find help with my problem.

I'm trying to develop a list of certain routes that my freight company ships on. I want to create a to/from list with all possible combinations of certain Major cities throughout the country...Ie. shipping from Tampa, FL to Los Angeles, CA..... shipping from Los Angeles, CA to Tampa, FL.

In my business the rates paid on these routes can be different in one direction or the other. It would be extremely useful to have a large list of these cities so that I could then calculate cost on each route and make adjustments weekly according to what the market asks for...

Only problem is that this list can only get bigger and bigger....and the list of possibilities for route combinations seems endless.

Here is just a short list of cities I'd like to have lists of all the possible routes for point A to B.

[TABLE="width: 135"]
<colgroup><col></colgroup><tbody>[TR]
[TD]BOSTON [/TD]
[/TR]
[TR]
[TD]Atlanta[/TD]
[/TR]
[TR]
[TD]Austin[/TD]
[/TR]
[TR]
[TD]Charleston[/TD]
[/TR]
[TR]
[TD]Chicago[/TD]
[/TR]
[TR]
[TD]Columbus[/TD]
[/TR]
[TR]
[TD]D.C / Baltimore[/TD]
[/TR]
[TR]
[TD]Dallas[/TD]
[/TR]
[TR]
[TD]Denver[/TD]
[/TR]
[TR]
[TD]Detroit[/TD]
[/TR]
[TR]
[TD]El Paso[/TD]
[/TR]
[TR]
[TD]Houston[/TD]
[/TR]
[TR]
[TD]Indianapolis[/TD]
[/TR]
[TR]
[TD]Jacksonville[/TD]
[/TR]
[TR]
[TD]Kansas City[/TD]
[/TR]
[TR]
[TD]Las Vegas[/TD]
[/TR]
[TR]
[TD]Long Island (Eastern)
[/TD]
[/TR]
[TR]
[TD]Long Island (Western)[/TD]
[/TR]
[TR]
[TD]Los Angeles[/TD]
[/TR]
[TR]
[TD]Memphis[/TD]
[/TR]
[TR]
[TD]Miami[/TD]
[/TR]
[TR]
[TD]Minneapolis[/TD]
[/TR]
[TR]
[TD]Nashville[/TD]
[/TR]
[TR]
[TD]OKC[/TD]
[/TR]
[TR]
[TD]Philadelphia[/TD]
[/TR]
[TR]
[TD]Phoenix[/TD]
[/TR]
[TR]
[TD]Pittsburgh[/TD]
[/TR]
[TR]
[TD]Portland[/TD]
[/TR]
[TR]
[TD]Salt Lake City[/TD]
[/TR]
[TR]
[TD]San Antonio[/TD]
[/TR]
[TR]
[TD]San Diego[/TD]
[/TR]
[TR]
[TD]San Francisco[/TD]
[/TR]
[TR]
[TD]Seattle[/TD]
[/TR]
[TR]
[TD]St Louis[/TD]
[/TR]
[TR]
[TD]Tampa[/TD]
[/TR]
</tbody>[/TABLE]


PLEASE HELP!

 

[rayk8301]

Hard for me to follow what you need done. What is the end result you want to see? What are the different rates for each of these cities you want to assign?

 

[hyprlteman]

That list of cities above...I'm trying to find all possible combinations of point A to Point B routes...

as in... Austin to Boston
boston to austin
atlanta to boston
atlanta to new york
new york to atlanta
atlanta to miami
miami to los angeles
los angeles to miami...

so on and so forth...

If I could figure out how to get excel to generate a list like that....I could generate individual pricing for each route...with n=35 and r=2 there should be 1190 permutations if I'm correct...