| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN to find specific lowest value
my data:
0 0 0 0 ..01 ..93 ..03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN to find specific lowest value
how about a nice array formula which must be entered/edited with
ctrl+shift+enter =MIN(IF(M2:M220,M2:M22)) -- Don Guillett SalesAid Software "Jane" wrote in message ... my data: 0 0 0 0 .01 .93 .03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN to find specific lowest value
Hi Don,
I tried the enter the formula at the end of my column but received #VALUE!. can you clarify what you mean by enter/ edit the array by using shift control enter? thank you, jane "Jane" wrote: my data: 0 0 0 0 .01 .93 .03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN to find specific lowest value
An "array" formula must be entered/edited with ctrl+shift+enter vs only
using the enter key. So when you create or change this formula hold down the control key and the shift key and touch the enter key. you will then see { } around the formula. This must be done whenever you make a change but NOT when copying down. -- Don Guillett SalesAid Software "Jane" wrote in message ... Hi Don, I tried the enter the formula at the end of my column but received #VALUE!. can you clarify what you mean by enter/ edit the array by using shift control enter? thank you, jane "Jane" wrote: my data: 0 0 0 0 .01 .93 .03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN to find specific lowest value
Thank you Don!
I got it! appreciate your time and information.... jane "Jane" wrote: my data: 0 0 0 0 .01 .93 .03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN to find specific lowest value
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
| How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Find lowest value in a range | Excel Worksheet Functions | |||
| How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
Linear Mode
