I have the following array formula which finds the minimum reference year (H6:Q6) which corresponds to any of the cells below (in H8:Q12) having a non-zero value:
={MIN(IF(H8:Q12<>0,H6:Q6,9999))}
However, the formula above mistakes a text string (e.g., "a") as a non-zero value, so I tried to...