Originally Posted by Max

.. If I had the ability to show you my spreadsheet,
it would make things easier,

Yes, definitely. Perhaps you could use either of the 2 free filehosts listed
below to upload your sample (desensitized as necessary) and then post the
link to it in response here (the link is generated when you upload, just
copy and paste it here)

http://www.flypicture.com/
http://cjoint.com/index.php

For cjoint.com (it's in French), just click the "Browse" button, navigate to
folder select the file Open, then click the button centred in the page
below (labelled "Creer le lien Cjoint") and it'll generate the link. Then
copy & paste the generated link as part and parcel of your response here.

... alternatively, you could send your sample over to me at:


I'd prefer the former, though, which keeps discussions visible here for the
mutual benefit of all.

But whichever track you decide to take, pl post a reply here to let me know
...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"frankjh19701" wrote in message
...
In my original post I had said that there are multiple choices for each
column. You're only showing me how to match one choice from each column.
If you need some examples, here's a few I can release:
Column A = Supplier's names such as Petro, Gasol, Fueldem, and Racex.
Column B = Terminal's names such as Penn, DellC, SinSpr, Newk. Column C
= Carrier's names such as Transport, Sytems, DriverB, LeeLLC. Column D =
Distance from Terminals such as 4496, 4500, 3890, 4800. Column E = The
Carrier's Rates (Which can depend on mileage from terminal to customer,
amount of freight carried (Plus or minus certain weights), or a
combination of the two. They can be such as 0.25, 0.12, 0.33, 0.44 -All
multiplied by the mileage, or they can be by weight, which is 8000 or
<7500, and by commodity shipped(Which I've had on the Y-axis down the
first column. So, if you read it from left to right across the
worksheet, it could read that you're looking for the lowest cost of a
commodity from the shortest distance location, and the least expensive
carrier to deliver it. (Maybe even the next cheapest as well). If I had
the ability to show you my spreadsheet, it would make things easier, I
think. Please let me know if this explanation helps at all.