View Single Post
  #1   Report Post  
dave
 
Posts: n/a
Default find smallest number not equal to 0

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