Find MIN but not zero.....

Z

Zadig Galbaras

Hi U all!

Let's say I have a list of numbers down a collomn A1:A7 containing
1,3,0,6,4,0.

By using the MIN() function I can easily find the lowest number in that
columni i e. the zero, but I want to get the number with lowest value,
_exept_ the zeros.

Is this possible to do?
 
C

Chip Pearson

Zadig,

Try the following array formula:

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

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this correctly, Excel will
display the formula enclosed in curly braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
F

Frank Kabel

Hi
try the following: If your data is in column A use the following array
formula (entered with CTRL+SHIFT+ENTER)
=MIN(IF(A1:A100<>0,A1:A100))
If you have negative numbers MIN would return those
 
Z

Zadig Galbaras

Thanks Chip!
This did the trick...
I'm all smile now!!
Thanks a lot!
--ZG--
 
Top