good call. adds clairification that i didn't specify.

regards
FSt1

"L. Howard Kittle" wrote:

In the sequence column, (C here), first cell =IF(B1"",1,"")
In the second cell and pull down =IF(B2=B1,C1+1,1)

HTH
Regards,
Howard

"DataGuy" wrote in message
...
Hello,

I have a list of employee ID numbers in column "A". I need a formula to
count starting with one but, when the employee ID changes, I need to start
a
new count again starting with one. Incase what I said above is confusing,
below is a sample of what I need to achieve. I need a counting formula to
calculate column "B" but change when the employee ID changes.

Employee ID Sequence
10001 1
10001 2
10001 3
10001 4
10001 5
10001 6
10002 1
10002 2
10002 3
10002 4
10002 5
10002 6
10002 7
10003 1
10003 2




.