Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MIN excluding 0s
Hi, I need to find the lowest value in a row, excluding zeros.
If I use the formula below as an array, I only get a #N/A returned: =MIN(IF(H38:J380;H38:K38)) How to do it correctly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
excluding cells from the formula when empty | Excel Worksheet Functions | |||
Count Days excluding Sundays | Excel Worksheet Functions | |||
Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions |