If I have a string of numbers in a column starting with 1 going thru 20 and I were to delete the middle number (11-15; esentially removing 5 lines), how would I set up the cells to now re-number the rows 1 thru 15?
I've attached an example for clarity.
CheddarThief
Last edited by cheddarthief; 08-18-2011 at 09:24 AM. Reason: Solved
Probably the easier way is, in your example, to replace the value 1 with the formula:
=ROW()-4
And copy that all the way down your list of numbers. You can now delete rows on a whim and the numbers will stay sequential.
Andrew, that worked great. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks