Most valuable professional
  • Hot Topics

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

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel