Hi
Try, for ex., this array formula:
=MIN(IF(COUNTIF($E$2:$E$4,$A$2:$A$6),IF(ISNUMBER(B2:B6),B2:B6)))
Hi
Try, for ex., this array formula:
=MIN(IF(COUNTIF($E$2:$E$4,$A$2:$A$6),IF(ISNUMBER(B2:B6),B2:B6)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks