Thread: [Solved] How do you add values in a column when determining the lowest amount within multiple groups
View Single Post
 
Old 09-06-2018, 07:38 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
See https://exceljet.net/formula/max-if-criteria-match

Try this array formula in E2 to get the discount
Code:
=IF($C2<MAX(IF($A$2:$A$20=$A2,$C$2:$C$20)),IF($B2="TC",0.5,0.25)*$C2,0)
confirmed with Shift+Ctrl+Enter not just Enter
and drag down
Attached Files
File Type: xlsx wheddingsjr_Example.xlsx (10.5 KB, 9 views)
Reply With Quote