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
