I am trying to figure out a formula to re-sequence numbers in a column. I have "Item" numbers 1:30 in Column A. "Item Descriptions" are in Column B. If I delete a ROW, I want the number below the deletion and all subsequent numbers to be sequentially renumbered/changed. For example, if I delete one row, then the last number will now be 29. Hopefully I have described this adequately.
In column A, replace the hard coded numbers with this excel formula
=ROW()
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This works if the first number, 1, is in Row/Cell A1. But what if the first number starts in Cell A3 (for example). Thanks!
=row()-2 would be my suggestion
Re: Formula to re-sequence sequential numbers in a column
=Row( )-2 is the solution! Many thanks!!
Here's another one...
Let's assume you want to start the sequence in cell A2.
Enter this formula in A2 and copy down as needed:
=ROWS(A$2:A2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks