Find MIN but not zero.....

  • Thread starter Thread starter Zadig Galbaras
  • Start date Start date
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?
 
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
 
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
 
Back
Top