In Last week’s video I showed you how to generate sequential ID numbers automatically when a new row was added at the bottom of a Table. I was then contacted by a viewer, Greg during the week. Greg said…
I’ve been using sequence numbers for years for various spreadsheets.
However, I routinely add the newest entry as the top row of the table.
I like this since I don’t have to scroll down to find the most recent item. Up to now, I’ve been inserting a row and copying the formula up from the last-used row. Is there a way to accomplish this similar to what you did in this video?
In this week’s video I answer Greg’s question.
The formula that I used in the video:
=”TET-” & TEXT(ROWS(SupportCalls)-ROW()+4,”00000″))