Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN will not find lowest of calculated values How?
pick up the lowest value of values 0?
Try this: =SMALL(U5:U15,COUNTIF(U5:U15,0)+1) -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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. Valko" wrote: 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. -- Biff Microsoft Excel MVP "Doc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the lowest value in a row | Excel Worksheet Functions | |||
Find lowest 3 values and sum | Excel Worksheet Functions | |||
find two (2) lowest values in a range (Excel) | Excel Worksheet Functions | |||
How do I find the position of the lowest value in a row? | Excel Discussion (Misc queries) | |||
How do I find the two lowest values in a range? | Excel Worksheet Functions |