Increment values only when there is a zero in a cell

[leenux_tux]

Hello Forum,

Hopefully someone has some pointers on this. Normally I can figure out little problems like this but this one has got me stumped. Obviously my Excel skill are not as good as I thought they were !!

Here is my challenge...

I have a set of numbers which are grouped, sometimes there is only one, sometimes 2, sometimes 3 sometimes 5. Some example data...

COLUMN A
0
0
1
0
1
2
3
4
5
0
1
2

In column b I want to do this...
COLUMN A, COLUMN B
0 1
0 2
1 2
0 3
1 3
2 3
3 3
4 3
5 3
0 4
1 4
2 4

I cannot for the life of me figure out a formulae that will auto-populate this for me. Any pointers would be greatly appreciated.

 

[thisoldman]

Try this.

=COUNTIF($A$1:A1, 0)

 

[leenux_tux]

Thanks for the fast response, works perfectly. I have used this formulae loads of times before so now I really feel stupid. !!