Results 1 to 3 of 3

Formula to keep row numbers sequential AFTER rows are deleted.

Threaded View

cheddarthief Formula to keep row numbers... 08-18-2011, 08:54 AM
Andrew-R Re: Formula to keep row... 08-18-2011, 09:03 AM
cheddarthief Re: Formula to keep row... 08-18-2011, 09:24 AM
  1. 08-18-2011, 08:54 AM #1
    cheddarthief is offline
    Forum Contributor
    Join Date
    02-20-2010
    Location
    Youngstown, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    182

    Formula to keep row numbers sequential AFTER rows are deleted.

    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
    Attached Files Attached Files
    Last edited by cheddarthief; 08-18-2011 at 09:24 AM. Reason: Solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1