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.