Find Minimum
A1 contains criteria, A1:A100 contains criteria to be matched and B1:B100 is the range to find the minimum value
{=MIN(IF(A1:A100=A1,B1:B100,""))}
Must be entered as array. (Push Ctrl, Shift and Enter simultaneously)
© Copyright
andrewsexceltips.net
All Rights Reserved.