Dear all,
I am struggling in finding a formula that can fulfill the following criteria
If we have a row that is like
1
1
2
2
2
3
1
1
2
2
1
2
3
I want to make it like
1
1
2
2
2
3
4
4
5
5
6
7
8
Practically after the first time of 1 any other 1 to be consecutive and the numbers after.
How do you think I can make it with a formula? Is there a way?
Thank you for your input in advance!
I am struggling in finding a formula that can fulfill the following criteria
If we have a row that is like
1
1
2
2
2
3
1
1
2
2
1
2
3
I want to make it like
1
1
2
2
2
3
4
4
5
5
6
7
8
Practically after the first time of 1 any other 1 to be consecutive and the numbers after.
How do you think I can make it with a formula? Is there a way?
Thank you for your input in advance!