ExcelBanter - finding minimum value

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - finding minimum value (https://www.excelbanter.com/excel-programming/395177-finding-minimum-value.html)

ezil

finding minimum value

I have to find minimum value in a range of column for eg. a1 to a100 other
than zero.
The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I
require
the minimum value other than zero (all my values are in positive side only)

Barb Reinhardt

finding minimum value

Try

=MIN(if(A1:A1000,A1:A100))

Commt with CTRL SHIFT ENTER

"ezil" wrote:

I have to find minimum value in a range of column for eg. a1 to a100 other
than zero.
The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I
require
the minimum value other than zero (all my values are in positive side only)

JE McGimpsey

finding minimum value

One way (array-entered: CTRL-SHIFT_ENTER or CMD-RETURN):

=MIN(IF(A1:A1000,A1:A100))

In article ,
ezil wrote:

I have to find minimum value in a range of column for eg. a1 to a100 other
than zero.
The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I
require
the minimum value other than zero (all my values are in positive side only)

All times are GMT +1. The time now is 05:29 PM.