Pricing Comparison

[Bitty]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Company 1[/TD]
[TD]( LBS)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Company 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Company 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orig[/TD]
[TD]Dest[/TD]
[TD]Min$[/TD]
[TD]100[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]5000[/TD]
[TD]10000[/TD]
[TD]Min$[/TD]
[TD]100[/TD]
[TD]500[/TD]
[TD]1000[/TD]
[TD]3000[/TD]
[TD]5000[/TD]
[TD]7500[/TD]
[TD]Min$[/TD]
[TD]100[/TD]
[TD]500[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]3000[/TD]
[TD]5000[/TD]
[TD]7500[/TD]
[/TR]
[TR]
[TD]ATL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BHM[/TD]
[TD]$25.95[/TD]
[TD]$7.76[/TD]
[TD]$7.12[/TD]
[TD]$6.30[/TD]
[TD]$4.76[/TD]
[TD]$3.45[/TD]
[TD]$39.82[/TD]
[TD]$13.36[/TD]
[TD]$13.09[/TD]
[TD]$12.54[/TD]
[TD]$12.03[/TD]
[TD]$11.34[/TD]
[TD]$10.67[/TD]
[TD]$40.00[/TD]
[TD]$11.13[/TD]
[TD]$10.89[/TD]
[TD]$10.40[/TD]
[TD]$9.92[/TD]
[TD]$9.92[/TD]
[TD]$9.31[/TD]
[TD]$8.70[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BNA[/TD]
[TD]$25.95[/TD]
[TD]$8.47[/TD]
[TD]$7.76[/TD]
[TD]$6.97[/TD]
[TD]$5.40[/TD]
[TD]$4.24[/TD]
[TD]$39.82[/TD]
[TD]$12.50[/TD]
[TD]$12.22[/TD]
[TD]$11.74[/TD]
[TD]$11.27[/TD]
[TD]$10.63[/TD]
[TD]$9.99[/TD]
[TD]$40.00[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[TD]$6.80[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BWI[/TD]
[TD]$34.60[/TD]
[TD]$11.25[/TD]
[TD]$10.31[/TD]
[TD]$10.12[/TD]
[TD]$9.37[/TD]
[TD]$8.25[/TD]
[TD]$39.82[/TD]
[TD]$25.92[/TD]
[TD]$25.39[/TD]
[TD]$24.34[/TD]
[TD]$23.35[/TD]
[TD]$22.04[/TD]
[TD]$20.74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CHA[/TD]
[TD]$25.95[/TD]
[TD]$7.76[/TD]
[TD]$6.90[/TD]
[TD]$6.04[/TD]
[TD]$5.21[/TD]
[TD]$2.81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]CLT[/TD]
[TD]$25.95[/TD]
[TD]$4.46[/TD]
[TD]$4.46[/TD]
[TD]$4.27[/TD]
[TD]$4.05[/TD]
[TD]$3.26[/TD]
[TD]$39.82[/TD]
[TD]$12.13[/TD]
[TD]$11.88[/TD]
[TD]$11.40[/TD]
[TD]$10.93[/TD]
[TD]$10.33[/TD]
[TD]$9.70[/TD]
[TD]$40.00[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[TD]$7.45[/TD]
[/TR]
</tbody>[/TABLE]

Hello All,

I am attempting to compare three carrier companies. I would like to find the lowest rates in multiple categories. I am not married to the formatting, I just don't know where to start with this project. Please see example above ...


Please help

 

[AhoyNC]

Maybe this will give you a start. I put each company in it's own table, but you could use the format you have above. If you could have different origins then you would need to add a vlookup to find the proper table. I also changed the min$ to 0 assuming min dollars would be for shipments under 100 lbs.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Company 1								Origin	ATL	Dest	BNA
2		0	100	1000	2000	5000	10000				Weight	2200
3	BHM	$25.95	$7.76	$7.12	$6.30	$4.76	$3.45				Rate	6.80
4	BNA	$25.95	$8.47	$7.76	$6.97	$5.40	$4.24				Company	Company 3
5	BWI	$34.60	$11.25	$10.31	$10.12	$9.37	$8.25
6	CHA	$25.95	$7.76	$6.90	$6.04	$5.21	$2.81
7	CLT	$25.95	$4.46	$4.46	$4.27	$4.05	$3.26
8
9	Company 2
10		0	100	500	1000	3000	5000
11	BHM	$39.82	$13.36	$13.09	$12.54	$12.03	$11.34
12	BNA	$39.82	$12.50	$12.22	$11.74	$11.27	$10.63
13	BWI	$39.82	$25.92	$25.39	$24.34	$23.35	$22.04
14	CHA
15	CLT	$39.82	$12.13	$11.88	$11.40	$10.93	$10.33
16
17
18
19	Company 3
20		0	100	500	1000	2000	3000	5000	7500
21	BHM	$40.00	$11.13	$10.89	$10.40	$9.92	$9.92	$9.31	$8.70
22	BNA	$40.00	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80	$6.80
23	BWI
24	CHA
25	CLT	$40.00	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45	$7.45
26
27
Sheet

 

[Bitty]

After applying this to my entire project, it worked perfectly! Thank you very much.