Insert increasing number into adjacent cells with the same value

[Tondonik]

Hello everyone,
I have a column with values either 0 or 1. Everytime there is one or more 0 below together, I need them to be replaced with increasing values by 1 and do not change the lines with previous 1. Like this:

1		1 /*no change
1		1 /*no change
0		1 /*+1
1	transform into ->	1 /*no change
0		1 /*+1
0		2 /*+2 (or previous cell +1)
0		3 /* +3 (or previous cell +1)
1		1 /* no change

Do you have any ideas? It needs to be done due to logistics reasons where adjacent zeroes represent a new line with another product of the same order, just for your information.
I will be greatful for your help.
Tony

 

[Fluff]

Hi & welcome to MrExcel.
How about

Book1
	A	B
1	Old	New
2	1	1
3	1	1
4	0	1
5	1	1
6	1	1
7	0	1
8	0	2
9	0	3
10	1	1
Report

Cell Formulas
Range	Formula
B2:B10	B2	=IF(AND(A2=0,A1=0),B1+1,IF(A2=0,1,A2))

 

[Tondonik]

Hi & welcome to MrExcel.
How about

Book1
	A	B
1	Old	New
2	1	1
3	1	1
4	0	1
5	1	1
6	1	1
7	0	1
8	0	2
9	0	3
10	1	1
Report

Cell Formulas
Range	Formula
B2:B10	B2	=IF(AND(A2=0,A1=0),B1+1,IF(A2=0,1,A2))

Hello Fluff and thank you so much!!! It works just great. I have not yet learned how to use IF/AND in Excel but will do now, it seems quite powerfull.
Have a nice day and all the best into 2020.
Tony

 

[Fluff]

You're welcome & thanks for the feedback