Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Hello,
From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Hi,
=MIN(IF(ISNUMBER(P3:P10)*P3:P100,P3:P10,"")) Array entered Mike "Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Hi,
The check for isnumber isn't necessary =MIN(IF(P3:P100,P3:P10)) Mike "Mike H" wrote: Hi, =MIN(IF(ISNUMBER(P3:P10)*P3:P100,P3:P10,"")) Array entered Mike "Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Hi MIke thank you !
I copied your formula then entert + cntr shift but it is not pasting the array - is this the only way? Thanks "Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Paste the formula in your cell then follow these intructions
'This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the formula {}. You can't type these yourself. If you edit the formula 'you must enter it again with CTRL+Shift+Enter. Mike "Arno" wrote: Hi MIke thank you ! I copied your formula then entert + cntr shift but it is not pasting the array - is this the only way? Thanks "Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Enter must be the last key held down.
Mike F "Arno" wrote in message ... Hi MIke thank you ! I copied your formula then entert + cntr shift but it is not pasting the array - is this the only way? Thanks "Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array: Show only min values greater than "0"
Thank you it worked now! Wisha good day ! Ciao Arno
"Arno" wrote: Hello, From the array below I need: show minimum values BUT greater then "0" (I must exclude zero) =MIN(IF(ISNUMBER(P3:P10),P3:P10,"")) Hope you can help -Thank you ! Arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show "+" (plus) sign when comparing two values | Excel Discussion (Misc queries) | |||
Find "Look in" box does not show 'values' on 'formulas' | Excel Worksheet Functions | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "? | Excel Programming | |||
Compare value to array of values, "best fit" (closest without going over, e.g. price is right) | Excel Programming |