CODEWITHSUNDEEP
excel
GCC
GCC

Reputation: 295

How to find the maximum value based on another column?

I am trying to find the maximum value based on another column. This is what I have tried.

=MAX(IF(Sheet3!$B$2:$B$5491=Sheet4!A3,Sheet3!$E$2:$E$5491))

How I am reading this code is that if the criteria in sheet 3 in column B is equivalent to the cell in A3 in sheet 4, then return the maximum value that would be in column E from sheet 3. I found this code online and have tried variations but all it is doing is returning 0. Is there another way I could go about finding the max value?

Thanks,

GCC

Upvotes: 2

Views: 698

Answers (1)

A.S.H
A.S.H

Reputation: 29332

It's an Array formula (aka CSE formula). After entering or editing it, you should press

CtrlShiftEnter

otherwise it won't work. Always remember this for array formulas.

Upvotes: 3

Related Questions