Hi
See below table.
<tbody>
Column
A
B
C
D
E
F
G
H
I
J
K
Row 1
236
533
112
236
533
112
</tbody>
I need a formulas for cell A1, B1 and C1 to include the first value in range E:J exceeding zero/non blank in A1, the second value in range E:J exceeding zero/non blank in B1 and the third...