Find Maximum

A1 contains criteria, A1:A100 contains criteria to be matched and B1:B100 is the range to find the maximum value

{=MAX(IF(A1:A100=A1,B1:B100,""))}

Must be entered as array. (Push Ctrl, Shift and Enter simultaneously)



© Copyright andrewsexceltips.net All Rights Reserved.