min >0 (97 SR2)

Topic

New Reply

Is there a function that will return the Minimum value greater than zero from a range of cells?

Reply | Quote

Replies

=MIN(IF(Range0,Range,FALSE)) this is an array formula. Enter using Ctrl+Shift+Enter
Also see:
http://www.cpearson.com/excel/lists.htm

Reply | Quote

I got an error message. I suppose i should have stated that the columns containing the datea to be evaluated are not adjacent.
They are in $AE22,$AA22,$W22,$S22. I tried to substitute this in your formula surrounded by Parenthasies “($AE22,$AA22,$W22,$S22)” for the word “Range”

Reply | Quote

You could do something like this:

=MIN(IF(S22>0,S22,999999999999999),IF(W22>0,W22,999999999999999),IF(AA22>0,AA22,999999999999999),IF(AE22>0,AE22,999999999999999))

Reply | Quote