Hi,
suppose my range in cells A1:A4 is 0,1,2,#DIV/0!
I would like to avoid a solution involving AGGREGATE (or SMALL(IF())- or MINIFS())
Apart from errors also zeroes should be excluded (or whatever other criteria added).
What would a solution involving MIN look like since =MIN(IF(ISNUMBER(A1:D1)*(A1:D1>0),A1:D1)) doesn't work and I am looking for a fairly sleek solution without unecessarily bloating the formula.
I also want to avoid nested IF-statements within the MIN-function ( e.g.: =MIN(IF(ISNUMBER(A1:D1),IF(A1:D1>0,A1:D1))) ) because the number of conditions can become quite long and I would like to keep the formula as readable as possible.
Thanks
Bookmarks