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?
|