LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default List of sequential numbers

I have a list of numbers 1-50.... if I delete a row, I want the
numbers to automatically adjust. The formula I had was
in cell A1 -- 1
In cell A2 -- A1+ 1
IN cell A3 --A2 + 1 etc

If you delete a row, the formulas does not work anymore

any ideas.

Thanks

Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a list of sequential numbers in Excel 2003? kateinmo Excel Discussion (Misc queries) 4 April 21st 07 06:48 AM
trying to store non-zero numbers from a list into sequential cells Ausseshooter New Users to Excel 4 February 4th 07 01:06 AM
How do i identify missing numbers in a sequential list Chet-a-roo Excel Discussion (Misc queries) 4 August 5th 05 07:25 PM
How do I create a list of sequential numbers using Excel or Acces. Clueless Excel Discussion (Misc queries) 1 April 5th 05 03:08 PM
list of sequential numbers kellyaek Excel Discussion (Misc queries) 2 December 3rd 04 04:45 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"