MIN functions

[jolly79_ph]

Hi, Im new of this excel functions:
a1=7, a2=4, a3=0, a4=5, a5=6

I have a data range a1 to a5, im trying to filter the lowest numbers
but the problem with the data range i have a zero figure on a3, which
don't like to reflect as the lowest but the a2=4.

How could i filter out the zero in MIN functions.

Can you help me pls. :

 

[Frank Kabel]

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