Thread
:
find smallest number not equal to 0
View Single Post
#
2
JE McGimpsey
Posts: n/a
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=MIN(IF(A1:A100<0,A1:A100))
In article ,
(dave) wrote:
What I want to do is find the lowest number in a column that is not equal to
0.
example
column A1
10
0
15
0
10
0
2
0
The result I want would be 2.
I tried =MIN(<0,Data!I5) but got an error.
Thanks
Reply With Quote