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
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
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=MIN(IF(A1:A100<>0,A1:A100))
In article <[email protected]>,
[email protected] (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
Array entered - meaning Ctrl_Shift-Enter
=MIN(IF((A1:A7)>0,A1:A7))
"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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks