Permutation list help needed...totally lost

hyprlteman

New Member
Joined
Feb 4, 2016
Messages
2
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.

BOSTON
Atlanta
Austin
Charleston
Chicago
Columbus
D.C / Baltimore
Dallas
Denver
Detroit
El Paso
Houston
Indianapolis
Jacksonville
Kansas City
Las Vegas
Long Island (Eastern)
Long Island (Western)
Los Angeles
Memphis
Miami
Minneapolis
Nashville
OKC
Philadelphia
Phoenix
Pittsburgh
Portland
Salt Lake City
San Antonio
San Diego
San Francisco
Seattle
St Louis
Tampa

<colgroup><col></colgroup><tbody>
</tbody>


PLEASE HELP!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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?
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,214,400
Messages
6,119,292
Members
448,885
Latest member
LokiSonic

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top