minimum value excluding zero

  • Thread starter Thread starter mkh
  • Start date Start date
M

mkh

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
 
One way:

=SMALL(D:D,1+COUNTIF(D:D,0))


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
Click to expand...
 
Back
Top