Auto sequential numbering even after moving rows

Happykamper56

Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows.

For example before moving the rows:

After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column:

I have looked at solutions posted in the past but they all rely on you not moving the first row. In my case, I will need to shift the first row around. Was wondering if anyone has any idea how I can approach this? Thanks!

Michelle Choate 2

Well you are not going to be able to do it in your auto number column. You will need to add one additional column. The formula is:

=MATCH([Row ID]@row, [Row ID]:[Row ID], 0)

Now you can move around your rows as much as you want.

Michelle Choate 2

Well you are not going to be able to do it in your auto number column. You will need to add one additional column. The formula is:

=MATCH([Row ID]@row, [Row ID]:[Row ID], 0)

Now you can move around your rows as much as you want.

Happykamper56

Wow @Michelle Choate 2 This worked perfectly! Thank you for the quick response!

Michelle Choate 2

My pleasure! Make sure to accept my response as the best answer to your question.