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

02/23/21
Answered - Pending Review

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#

Answers

  • Joseph GentileJoseph 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.


Sign In or Register to comment.