numbering a column
 

How do I number a column automatically (eg: 1. 2. 3. ...)?

numbering a column
 

Hi
not quite sure what you're trying to achieve but the following formula
will put a sequencing number
in column A, if column B is filled:

in A1 enter the following formula
=IF(B1<"",1,"")

in A2 enter the formula
=IF(B2<"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like

this formula will add a sequencing number in column a for all rows in
which
column B contains a value

--
Regards
Frank Kabel
Frankfurt, Germany

"boettcher" schrieb im
Newsbeitrag ...
How do I number a column automatically (eg: 1. 2. 3. ...)?