CODEWITHSUNDEEP
excelmaxifs
Jah-Lahfui
Jah-Lahfui

Reputation: 35

MAXIFs( ) to get max-value based on an array of values

I have a table like:

Type Value
A 11
A 3
B 1
C 7
B 11
C 8

Let's say I need to +MAXIF(Value, Criteria1=Type, Criteria1 = A&B)

How could I do this in excel? With MAXIF I can only do criteria for one letter in Type. The alternative I have is: MAX(MAXIF(value, Criteria1=Type, A); MAXIF(value, Criteria1=Type, B)

For sure there's a way to save all the work, using only +MAXIF only.

Thank you!

Upvotes: 0

Views: 20

Answers (0)

Related Questions