Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the minimum value in a range while ignoring zeros?
-- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the minimum value in a range while ignoring zeros?
If the numbers are *always* positive..
Array entered**: ..=MIN(IF(A1:A100,A1:A10)) Or, normally entered: =SMALL(A1:A10,COUNTIF(A1:A10,0)+1) If there might be negative numbers... Array entered**: =MIN(IF(A1:A10<0,A1:A10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Ted B." wrote in message ... -- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the minimum value in a range while ignoring zeros?
hi
try this..... =small(A1:A50,countif(A1:A50,0)+1) regards FSt1 "Ted B." wrote: -- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the minimum value in a range while ignoring zeros?
You could use a conditional MIN, something like this in say B2, array-entered
ie press CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER): =MIN(IF(A2:A100,A2:A10)) Success? hit the YES below -- Max Singapore --- "Ted B." wrote: -- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the minimum value in a range while ignoring zeros?
hi
forgot to mention. adjust ranges to suit your data. Regards FSt1 "Ted B." wrote: -- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Minimum but if same number repeats in the range, then find | Excel Discussion (Misc queries) | |||
How do I find minimum duplicated values in a range? | Excel Worksheet Functions | |||
How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
find minimum of range based on multiple criteria | Excel Worksheet Functions | |||
calculating the minimum value ignoring o | Excel Worksheet Functions |