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″))