Forum Discussion
I have a question about the MIN formula
I'm trying to find the minimum value in a column of numbers, but if the value is 0 I don't want to consider it. In other words, I'd like to ignore the zeros. I can't seem to find a way to do this wit...
The Minifs function suggested by Detlef_Lewin is an excellent choice, but it is only available if you have an Office 365 subscription.
If you have a different Office license, then you can try this formula:
=MIN(IF(A1:A5>0,A1:A5))
It is an array formula and must be confirmed with Ctrl-Shift-Enter, but it works in all versions of Excel.
Thanks. I have Office 365.