MIN will not find lowest of calculated values How?

D

Doc

I have a column of calculated values and MIN will not select the lowest
value. MAX will select the highest value. Is there another way to select
the lowest value since MIN will not work. I am using 2003
 
T

T. Valko

Not enough info!
I have a column of calculated values

Calculated how?

Tell us what formula you tried that doesn't work. What result did you get
with that formula?

I can assure you that MIN will work.
 
D

Doc

I am using a calculation of two other cells such as =c2+d2

I am search MIN in column U so =MIN(U5:U15)

It provides no answer.

If I try MAX instead of MIN, MAX works.

Sorry I did not get back to you sooner. I had a very difficult time
navigating to this message. The links in the email notification did not work.
 
T

T. Valko

I am search MIN in column U so =MIN(U5:U15)
It provides no answer.

Do you mean the cell appears to be blank?

Maybe the result is 0 and you have turned off 0 display, or do you maybe
have some conditional formatting applied to that cell?

I've never seen a formula not return a result. It may not be the result you
expect but they always return something.
 
D

Doc

You are right, there are 0 values in the (u5:U15) group.

What formula can I use to only pick up the lowest value of values >0?
 
T

T. Valko

pick up the lowest value of values >0?

Try this:

=SMALL(U5:U15,COUNTIF(U5:U15,0)+1)
 

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

Top