Automatic Numbering (Excel 2002)

[d_perotto]

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

[LegareColeman]

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

[sdckapr]

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

[sdckapr]

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