minimum value excluding zero
I missed they were all positive so you can use this
=MIN(IF(A1:A50,A1:A5))
Once again array entered
Mike
"mkh" wrote:
i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0
for example, if the row contains 100, 50, 30, 10, 0
the min value shown should be 10
the values are all postive values
thanx
|