Improve Sorting Formula

[kenyon76]

My Excel formula =MIN(IF(O3<B3:M3,B3:M3,"")) is basic and i can't figure out how to make it stop at numbers after 24 and leave the cells blank.

[Fluff13]

How about in O3 copied down & across

Please Login or Register  to view this content.

Are you still using 2013, or are you now using 365?

[kenyon76]

Thanks that worked perfectly.....

[Phuocam]

One way:

=IFERROR(AGGREGATE(15,6,$B3:$M3/($B3:$M3<=24)/($B3:$M3>N3),1),"")

[Fluff13]

You're welcome & thanks for the feedback