| 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? |
|
#2
|
|||
|
|||
|
oh, never mind. I just saw that I messed up a letter...
"Thore" schrieb: 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? |
|
#3
|
|||
|
|||
|
Hi Thore
ranges need to match H38:J38 Vs H38:K38 Cheers JulieD "Thore" wrote in message ... oh, never mind. I just saw that I messed up a letter... "Thore" schrieb: 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? |
|
#4
|
|||
|
|||
|
The two arrays must be the same size (end in column J or K?) and the
formula must be array entered (Ctrl-Shift-Enter). Jerry Thore wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
