Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Numbering (Excel 2000)

    How do you create a column that will automatically increment when a new entry is made. I know about Edit, Fill, Series but I was wondering if there is a way to format a column so that when the next entry in the spreadsheet is made, that cell automatically increments. Thanks for any help.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Auto Numbering (Excel 2000)

    Hi,

    Try something like this in cell A1 assuming when you put something in col B you want the sequence number:

    =IF(B1="","",ROW())

    Amend to suit your specific needs and copy it down as far as you need.

    Good Luck,
    Peter Moran
    Two heads are always better than one!

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Numbering (Excel 2000)

    Thanks so much. Works great.

Posting Permissions

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