find smallest number not equal to 0


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
 
Ad

Advertisements

J

JE McGimpsey

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MIN(IF(A1:A100<>0,A1:A100))
 
Ad

Advertisements

G

Guest

Array entered - meaning Ctrl_Shift-Enter

=MIN(IF((A1:A7)>0,A1:A7))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top