Dear Friend, You just need to use the following formula
A B C D City Carrier Total Diff Albertville A 700.00 In the D field type =C3-$C$3 and just copy and paste this to remaining below in the Diff field. Do revert for further clarification. Regards Mukesh Gupta On Thu, Aug 4, 2011 at 9:54 PM, dewbro2 <kdew...@brownmre.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
