=MIN(IF(A1:E1>0,A1:E1)) works fine, but I want to find the Min Value excluding zeros for only cells A1, C1, and E1.
=MIN(IF((A1,C1,E1)>0,(A1,C1,E1))) returns #VALUE
Is there a better way to find the minimum while excluding zeros for individually selected cells?
Bookmarks