Auto Numbering

L

linuskmj

I would like to know if there is any method whereby an auto number can
be generated for me in the first column (A) for each record i enter ?

Example
1 ABC
2 ABCD
3 ...
4 ...
and so on
 
G

Gord Dibben

One method if entering data in column B......

=IF(B1<>"",1,"") entered in A1

=IF(B2<>"",A1+1,"") entered in A2 and copied down as far as you wish

Hang in. I'm sure there will be more elegant methods suggested.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Auto populate value from one task to another in MS PROJECT 0
How to replace text with numbers? (formula) 4
Global Template Network and saving auto texts & macros 2
Finding the right style field in VBA 0
Section and Page numbering 0
Word- Find and Replace 1
Auto-Numbering in a Table in MS Word 1

Top