ExcelBanter - MIN or DMIN ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - MIN or DMIN ? (https://www.excelbanter.com/excel-worksheet-functions/32875-min-dmin.html)

Douglas McDonald

MIN or DMIN ?

I need to find the min in a column but don't want (0's) zeros

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

"Douglas McDonald" wrote:

I need to find the min in a column but don't want (0's) zeros

All times are GMT +1. The time now is 07:07 AM.