Consecutive Numbers

[ddecheva]

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!

 

[FormR]

can i ask what the "N" does

Hi, It's a worksheet function:

https://www.techonthenet.com/excel/formulas/n.php

It is used in this context to avoid an error in the first instance of the formula.

 

[AkaTrouble]

Its needed to convert the header to zero or the first sum would fail.

thanks i never seen that before but have encountered the problem lol .. now i have a solution

edit

FormR

Thanks

 

[ddecheva]

Additionally,

After I do the consecutive numbers I need to create random "Fake" 14 to 18 digit numbers, which correspond to those numbers. I will explain better with an example

1 1234567891011
1 1234567891011
2 1234567891012
2 1234567891012
2 1234567891012
3 1234567891013
4 1234567891014
5 1234567891015
5 1234567891015
6 1234567891016
7 1234567891017
8 1234567891018

The ending of the 14 digit number, however, does not need to end like the number to which correspond. The only rule is for all 1s,2s,3s and etc. to be the same.

Do you think this is feasible?

I forgot to mention that the 14 to 18 digits number should be unique. It should not repeat at all.

 

[steve the fish]

Im lost to what you are asking for here. You say unique but your examples aren't unique.

 

[ddecheva]

They are unique for 1,1,2,2 and etc.

But if I have another batch of 1,1,2,2 then I need new unique 14 to 18 numbers for them

 

[steve the fish]

Just add 1234567891010 to your already given equation.

 

[ddecheva]

Just add 1234567891010 to your already given equation.

I actually used the same logic as with the other consecutive numbers and it is working as well.

Thank you all for your quick and accurate replies

Enjoy the weekend!