Minimum Functions

[jolly79_ph]

HI, IM NEW ON THIS FORUM, BUT IM INTERESTING OF THE WONDERS OF EXCE
PROGRAM.

data range: A1=3, A2=6, A3=0, A4=9, A5=6

USING MIN function: filter out the lowest number with A1:A5 IS=3
PROBLEM: ZERO NUMBER
when im using the =MIN(A1:A5) THE ANSWER IS ZERO.
BUT I DON'T WANT TO CONSIDER ZERO AS THE LOWEST NUMBER.
HOW COULD I DO THE FORMULA?

PLS HELP ME ::

 

[Frank Kabel]

Hi
you have already received an answer to this in your ither thread )

 

[jolly79_ph]

Hello, Frank kabel

I didn't find your reply about my problem on Minimum Functions, pl
post me again your answer on my problem about how to filter the zero
or what kind of functions i use, reference:

Data range: A1=3, A2=6, A3=0, A4=9, A5=6

USING MIN function: filter out the lowest number with A1:A5 IS=3
PROBLEM: ZERO NUMBER
when im using the =MIN(A1:A5) THE ANSWER IS ZERO.
BUT I DON'T WANT TO CONSIDER ZERO AS THE LOWEST NUMBER.
HOW COULD I DO THE FORMULA?

PLS HELP ME

 

[Frank Kabel]

Hi
try the array formula (entered with cTRL+SHFT+ENTER):
=MIN(IF(A1:A5<>0,A1:A5))

 

[jolly79_ph]

Hi Frank,


It works! on the data i sample you, but i had a problem if the data i
not range, meaning non-adjacent data like this: a1=2, a3=4, a5=0, a7=8
a10=6.

How do i correct the argument of this function with your suggeste
formula?

thanks again your a great guru of excel.

Jolly7

 

[Frank Kabel]

Hi
best way: change your data layout
If this is not possible it would be helpful if there's a logic in your
used cells. e.g. every 2nd cell or something similar.