Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating 0 values when using the Small formula
Good morning:
I have a range of numbers that contain the value 0... For instance assume each number is in a cell: 0,100,0,800,200,0,150,80 How could I write the SMALL formula to have 80 as the smallest value instead of 0? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating 0 values when using the Small formula
Based on your sample with all values being positive:
=SMALL(A1:A8,COUNTIF(A1:A8,0)+1) Or, array entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =MIN(IF(A1:A80,A1:A8)) Biff "MIchel Khennafi" wrote in message ... Good morning: I have a range of numbers that contain the value 0... For instance assume each number is in a cell: 0,100,0,800,200,0,150,80 How could I write the SMALL formula to have 80 as the smallest value instead of 0? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |