I need to find the min in a column but don't want (0's) zeros
P Peo Sjoblom Jun 28, 2005 #2 If there are no negative values =LARGE(A1:A30,COUNTIF(A1:A30,">0")) if there are negative values =MIN(IF(A1:A30<>0,A1:A30)) the latter needs to be entered with ctrl + shift & enter Regards, Peo Sjoblom
If there are no negative values =LARGE(A1:A30,COUNTIF(A1:A30,">0")) if there are negative values =MIN(IF(A1:A30<>0,A1:A30)) the latter needs to be entered with ctrl + shift & enter Regards, Peo Sjoblom
