Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions | |||
putting a number equal to writing commands | Excel Worksheet Functions | |||
Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
Find all cells with a number and mulitply | Excel Discussion (Misc queries) | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |