Numbering - Starting Over Based on Zero
I have a sheet that is like this:
A B C
content 0 Yes
content
content
content 0 Yes
content
content
content
content
content 0 Yes
content
content
content
What I want to do is number column b as 0,1,2,3,4,5 etc and start over
numbering when it hits a 0.
How would I do that with a macro....or is there an easier way.
Any help would be so appreciated.
Thanks,
Louise
|