Excel: Autonumber Column without Code

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Andrea Andreou

Thread Starter
Joined
Oct 1, 2001
Messages
33
Hi,

Can anyone please tell me if it is possible to have an auto number formular on an excel spreedsheet template (similar to the auto number field used in access).

Your assistance would be appreciated.

Thanks.

Andrea.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Well, we all kind of work around that one.

Suppose you have a spreadsheet and you want an "autonumber" in column A, and suppose you enter a date in column B.

Assuming you start your "autonumber" on row 3 (because you type a 1 in A2), type this formula into A3:

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

Then you copy that down as many cells as you think you'll need.

There's probably a way to accomplish it using code. I'll look around if you're interested in that.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top