#shorts | How to Get MAX Value Basis on Condition | Conditional MAX

to get MAX value from range basis on condition in the older version of Excel, you can use MAX Function, it's become an array formula hence you need to press Control + Shift + Enter.

#shorts
#max
#maxifs
#excel

[sTPSTbam]

Thank you, sir. You help me so much! ❤❤❤❤

[Rawyu]

It is necessary to use ctrl+shift+enter to work effectively

[vijaydagar]

Very nice, one question how to use it's if data required on another sheet.

[harsinchh]

Sir, how to find max value which is above any particular value.
for eg. find the max value that is above value 7.

[mailsanchar]

Sir how to do it for Minimum value? I put MIN in place of MAX but didn’t work.