hi,

I have a list of names in column B, i want to write something that basically puts a number in column a if there is an entry in B so i have a running count e

1 AB
2 FG
3 XY

any ideas pls.

Hi
the following formulas 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


--
Regards
Frank Kabel
Frankfurt, Germany

"kevin" schrieb im Newsbeitrag
...
hi,

I have a list of names in column B, i want to write something that
basically puts a number in column a if there is an entry in B so i have
a running count eg

1 ABC
2 FGH
3 XYZ

any ideas pls.