tuqiuchiaa
New Member
- Joined
- Mar 12, 2018
- Messages
- 3
Hi,
I'm trying to figure out a way to count the number of cells in the first non-zero Consecutive cells.
Been reading all the posts about consecutive cells posts, but couldn't get anything working.
Could anyone help? Thanks in advance!
The desired results are listed below
<tbody>
</tbody>
I'm trying to figure out a way to count the number of cells in the first non-zero Consecutive cells.
Been reading all the posts about consecutive cells posts, but couldn't get anything working.
Could anyone help? Thanks in advance!
The desired results are listed below
A | B | C | D | E | F | Result | |
2 | 1 | 2 | 0 | 0 | 0 | 3 | |
0 | 0 | 20 | 32 | 0 | 0 | 2 | |
0 | 0 | 1 | 10 | 0 | 1 | 2 | |
1 | 0 | 231 | 2 | 2 | 1 | 1 |
<tbody>
</tbody>