Numbering Sequence
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
.
|