| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MIN with zero values in the range
How do I get the minimum number in a range EXCLUDING ZEROS? I have a range
and some cells in the range have a zero balance. MIN ordinarily would be zero, but I want the next smaller number. So far I do not have a clue on how to get there. TIA! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get absolute values for a range of cells? | Excel Discussion (Misc queries) | |||
| Checking ALL values in a range | Excel Discussion (Misc queries) | |||
| How to move Y-axis values when X range is -a to +b | Charts and Charting in Excel | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
