Match and Min but greater than zero

[dml5055]

Hi,

I'm trying to get an array formula to find matching data in column C:C, and return the minimum values in column O:O. I have this formula now:

{=min(if(C:C=c1,O:O)}

but this also returns zero's when there is a match. i would like to pull up the minimum number that matches but are greater than zero

any suggestions?

Thanks!

 

[AlphaFrog]

Try something like this...
{=min(if((C:C=c1)*(O:O>0),O:O))}

 

[dml5055]

thanks!