I want to check an array/row,
-
ignoring non-blank cells (setting to
""
), -
numbering empty cells from 0 to n,
-
resetting the number to 0 if the next non-blank cell is found.
-
stopping at the last cell
So, it'd look like this:
A B
0 APPLE
1 0
2 1
3 BANANA
4 0
5 1
6 2
7 CHERRY
8 DURIAN
9 0
10 EGG
A is the original and B is what the function is applied.
Aucun commentaire:
Enregistrer un commentaire