Hello All,
I'm trying to get a formula to count with sequence number of "0" and "1" from data row #2 . The result should be looked like
in the row #4 and row #5 . If there is an "A", then I just need to copy it to the same row as number/Letter in the front of it.
I appreciate any help that you can provide.
*BDT
<tbody>
</tbody>
I'm trying to get a formula to count with sequence number of "0" and "1" from data row #2 . The result should be looked like
in the row #4 and row #5 . If there is an "A", then I just need to copy it to the same row as number/Letter in the front of it.
I appreciate any help that you can provide.
*BDT
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
1 | |||||||||||||||||
2 | data | 1 | 1 | A | 1 | 0 | 0 | A | 1 | 1 | 0 | 0 | A | A | 0 | A | 0 |
3 | |||||||||||||||||
4 | count "0" | 1 | 2 | A | 3 | 4 | A | A | 5 | A | 6 | ||||||
5 | count "1" | 1 | 2 | A | 3 | 4 | 5 |
<tbody>
</tbody>