Auto Numbering

  • Thread starter Thread starter linuskmj
  • Start date Start date
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
 
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
 
Back
Top