How do you add values in a column when determining the lowest amount within multiple groups

NoSparks · #1 09-06-2018, 07:38 PM

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

wheddingsjr · #2 09-07-2018, 07:01 AM

Thanks NoSparks

This was VERY helpful. Unfortunately though, the highest number should not calculate and populate, its only those that are less than it. I am not sure what you mean by "confirmed with Shift+Ctrl+Enter not just Enter and drag down". I thought perhaps thats why the high number is being populated because when I do the "Shift+Ctrl+Enter not just Enter nothing happens.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
append multiple time values to date in one column	sarahafeez	Excel	1	09-25-2017 11:01 PM
2-Column layout breakes with images/groups	ben-in-m	Word	0	06-02-2017 01:26 PM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM