# Thread: Repeat Numbering for like ID's Thanks: 0 Likes: 0

1. ## Repeat Numbering for like ID's

Hi, I have id's numbers that repeat and i need to count them with the same "row number" the formula I've come up with is: =if(b2=b1,"1",a1"+1"). each change in employee number it starts over to row number 1. what am i missing
 Row Number ID Number 1 123421 1 123421 2 222323 2 222323 2 222323 3 434344 3 434344 4 545443

2. ## Re: Repeat Numbering for like ID's

I think this may be what you are looking for:
Code:
`=if(b2=b1,a1+1,1)`

3. ## Re: Repeat Numbering for like ID's

If you want this result, You must start with 1 in cell A1 and in cell A2 put the formula:

=IF(B2=B1,A1,A1+1)

 A B 1 1 123421 2 1 123421 3 2 222323 4 2 222323 5 2 222323 6 3 434344 7 3 434344 8 4 545443

----
if you want this, You must start with 1 in cell A1 and in cell A2 put the formula:

=IF(B2=B1,A1+1,1)

 A B 1 1 123421 2 2 123421 3 1 222323 4 2 222323 5 3 222323 6 1 434344 7 2 434344 8 1 545443

4. ## Re: Repeat Numbering for like ID's

Thank you!!! worked!!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•