Excel: Consecutive Numbers


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!


This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of March 10, 2017.


For more resources for Microsoft Excel