Hi Mukesh Did you shoot this query again , I have sent a solution for this , see the attached sheet, Revert if any query you have?
From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Friday, August 05, 2011 6:02 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria Try this =C3-MIN(OFFSET(INDEX(A:A,MATCH(A3,A:A,0),1),,2,COUNTIF(A:A,A3),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Gupta Sent: Friday, August 05, 2011 2:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Subtract the minimum value based on multiple criteria 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 -- ---------------------------------------------------------------------------------- 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
Function.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet