View Single Post
  #1   Report Post  
Thore
 
Posts: n/a
Default 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?