Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Numbering (Excel 2002)

    I think I need a function? I'm creating a spreadsheet. Cell A1 is called Item Number. Cell B2 is called Name. I want cell A2 to show up as 1 (Which is relating to the record number). Then I enter a name in cell B2. When I enter another record starting in cell A3 (I want it to automatically emter 2 for me). Yhen go to cell A4 and automatically enter a 3 etc. Help

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Numbering (Excel 2002)

    Steve: I think you meant to say put that formula in A2 (not B2) and copy it down.
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatic Numbering (Excel 2002)

    EDITED to correct mistake, pointed out by legare. Steve

    Something like this copied from A2 to whatever should work:

    =if(isblank(b2),"",1+a1)

    Steve

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automatic Numbering (Excel 2002)

    Legare,
    Thanks for catching my error. I have edited the post to correct it.
    Steve

Posting Permissions

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