How can I create a column that always reflects the current row#?

Jennifer Jeremy

How can I create a column that always reflects the current row#?

I've tried the System Column/Auto-Number, but cannot get the assigned numbers to match the current Row#

Joseph Gentile

Hi Jennifer,

Here's one idea. You would need to create 2 columns.

1. Auto Row ID
2. RankEQ Formula (Converted to Column Formula)
3. Formula =RANKEQ([Row ID]@row, [Row ID]:[Row ID], 1)

The auto-row ID will change as rows get added or deleted but you can use the RankEQ formula to reference the row ID and rank sequentially; 1,2,3,…….999

As long as you have the sheet sorted by "Row ID" the RankEq formula works.

Attached is a screenshot of the concept.

Joseph Gentile

Hi Jennifer,

Here's one idea. You would need to create 2 columns.

1. Auto Row ID
2. RankEQ Formula (Converted to Column Formula)
3. Formula =RANKEQ([Row ID]@row, [Row ID]:[Row ID], 1)

The auto-row ID will change as rows get added or deleted but you can use the RankEQ formula to reference the row ID and rank sequentially; 1,2,3,…….999

As long as you have the sheet sorted by "Row ID" the RankEq formula works.

Attached is a screenshot of the concept.

Jennifer Jeremy

Thank You, Joseph for the response. I will give this a try!