Forum Discussion
Lynne Robinson
Sep 03, 2017Copper Contributor
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...
Detlef_Lewin
Sep 03, 2017Silver Contributor
Lynne,
use MINFIS().
=MINIFS(A1:A6,A1:A6,">0")