I have a worksheet that tracks rates for multiple lanes by multiple carriers. I am trying to find an easy way to calculate the difference between the rate for each carrier on a lane and the lowest rate for a given lane. I am spending a lot of time manually correcting formulas, and I would like to have 1 formula that I can copy throughout the worksheet. Example: Where the City is Albertville, the lowest rated lane is Carrier A at $700 dollars, so I want the value of "zero" in the "Diff" field (=sum(C1-C1)). However for Carrier E for the Albertville lane, I want a value of 536.50 in the "Diff" field which is the difference between the rate in cell C6 and the minimum rate in cell C1. I will need to do this for every carrier/lane in my worksheet and there are thousands of these entries. Hope this makes sense. Any solutions would be GREATLY appreciated.
ROW/COL A B C D 1 City Carrier Total Diff 2 Albertville A 700.00 0.00 3 Albertville B 725.00 25.00 4 Albertville C 728.00 28.00 5 Albertville D 750.00 50.00 6 Albertville E 1,236.50 536.50 7 Albertville F 1,323.11 623.11 8 Albertville G 1,374.75 674.75 9 Albertville H 1,834.75 1,134.75 10 Bessemer A 500.00 0.00 11 Bessemer B 525.00 25.00 12 Bessemer C 550.00 50.00 13 Bessemer D 560.00 60.00 14 Bessemer E 570.00 70.00 15 Bessemer F 700.00 200.00 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
