| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Minimum Value in series, excluding zero values
I am trying to find the smallest value in a series, but exclude the
cells that have zero values. For Example: A B C D E F G 2 1.1 4 0 0 0 0 I want the return value to be 1.1 (the smallest in the row excluding 0) Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find missing values in a series | Excel Worksheet Functions | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Finding Min Cell values excluding zero in alternate columns | Excel Worksheet Functions | |||
| finding values and displaying adjacent values | Excel Worksheet Functions | |||
| Help needed in finding specific series via row. | Excel Worksheet Functions | |||
Threaded Mode
