Undertegnede
New Member
- Joined
- Oct 15, 2013
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hi,
I want to be able to count 0's after the last 1 in my spreadsheet. The number i want counted is listed in my "="-column.
Anyone able to assist please?
<tbody>
</tbody>
I want to be able to count 0's after the last 1 in my spreadsheet. The number i want counted is listed in my "="-column.
Anyone able to assist please?
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | = |
1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 |
0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 |
0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 |
<tbody>
</tbody>