debruintjie
New Member
- Joined
- Sep 9, 2014
- Messages
- 5
Hi
See below table.
[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD="align: center"]Column[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]236[/TD]
[TD]533[/TD]
[TD]112[/TD]
[TD][/TD]
[TD][/TD]
[TD]236[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]533[/TD]
[TD]112[/TD]
[/TR]
</tbody>[/TABLE]
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 value in range E:J exceeding zero/non blank in C1.
Kind regards
See below table.
[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD="align: center"]Column[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD]Row 1[/TD]
[TD]236[/TD]
[TD]533[/TD]
[TD]112[/TD]
[TD][/TD]
[TD][/TD]
[TD]236[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]533[/TD]
[TD]112[/TD]
[/TR]
</tbody>[/TABLE]
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 value in range E:J exceeding zero/non blank in C1.
Kind regards