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

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#

Best Answer

  • Joseph Gentile
    Joseph Gentile ✭✭✭✭
    Answer ✓

    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.


Answers

  • Joseph Gentile
    Joseph Gentile ✭✭✭✭
    Answer ✓

    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.


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