Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min. Value is Needed
I am trying to determine the min value of a column using the MIN command.
The column has the following values: 2 34 6 0 0 1 I would the minium value greater then zero to be displayed in a cell. I have been able to use the Max command to determine the mx number but and Min command displays 0 or if I setup a negative number it will display that value. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min. Value is Needed
=MIN(IF(A1:A60,A1:A6)) Enter with Ctrl+Shift+Enter (an array formula). You will {} brackets enclosing the formula if entered correctly. HTH "Val" wrote: I am trying to determine the min value of a column using the MIN command. The column has the following values: 2 34 6 0 0 1 I would the minium value greater then zero to be displayed in a cell. I have been able to use the Max command to determine the mx number but and Min command displays 0 or if I setup a negative number it will display that value. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min. Value is Needed
One way
=LARGE(A1:A10,COUNTIF(A1:A10,"=0")-2) -- Regards, Peo Sjoblom "Val" wrote in message ... I am trying to determine the min value of a column using the MIN command. The column has the following values: 2 34 6 0 0 1 I would the minium value greater then zero to be displayed in a cell. I have been able to use the Max command to determine the mx number but and Min command displays 0 or if I setup a negative number it will display that value. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needed Help.. | Excel Worksheet Functions | |||
Help needed | New Users to Excel | |||
Help needed | Excel Worksheet Functions | |||
Help Needed - Please | Excel Discussion (Misc queries) | |||
help needed | Excel Worksheet Functions |