D
dave
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
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