Snasui Excel Forum

Bo_ry wrote: Mon Jan 25, 2021 12:47 pm =MIN(IF(ISNUMBER(SEARCH($A$2:$A$22,E10)),$B$2:$B$22))
=MIN(IF(($A$2:$A$22=E2)+($A$2:$A$22=E3),$B$2:$B$22))


=MAX(IF(ISNUMBER(SEARCH($A$2:$A$22,E10)),$B$2:$B$22))
=MAX(IF(($A$2:$A$22=E2)+($A$2:$A$22=E3),$B$2:$B$22))