Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How do I calculate the minimum figure but ignoring and 0 values
For example: 8 0 5 8 0 2 4 0 3 7 8 the I looking for is 2 |
#2
![]() |
|||
|
|||
![]()
If no negative entries in the range of interest:
=SMALL(Range,COUNTIF(Range,0)+1) Otherwise: =MIN(IF(Range,Range)) which must be confirmed with control+shift+enter, not just with enter. jo jo wrote: How do I calculate the minimum figure but ignoring and 0 values For example: 8 0 5 8 0 2 4 0 3 7 8 the I looking for is 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
lookup - return minimum value | Excel Worksheet Functions | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |