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
-
Hi Jennifer,
Here's one idea. You would need to create 2 columns.
- Auto Row ID
- RankEQ Formula (Converted to Column Formula)
- 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
-
Hi Jennifer,
Here's one idea. You would need to create 2 columns.
- Auto Row ID
- RankEQ Formula (Converted to Column Formula)
- 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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives