minimum value excluding zero

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
Word macro that can call cells out of Excel for a find and replace 0
Auto populate value from one task to another in MS PROJECT 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Calculate the median value before a specified list 0
sum vlookup results 5
Drop down list control value in vba 2
The data for the search should be organized in a single contiguousrange in one column. 3

Top