# Identifying Duplicate Values (2nd, 3rd, and 4th occurance)

1. ## Identifying Duplicate Values (2nd, 3rd, and 4th occurance)

Hi so the issue here is that I have a list of "GPC" or company identification numbers. And for every campaign being sent to the company it will have the same GPC of identification code. I want a formula that indicates if it is the first time mailing the company (as a result return nothing for column D ""), the second time mailing them, third, or fourth. So basically I need a formula to find the duplicate values and return whether it is the first, second, third, or fourth time that code appears in column A.

The current formula I have is a little off because it checks against the cell beforehand. I'm not sure how to modify the formula or what different forumla I need. Attached is an example. I am looking at column A and trying to return the data in D. You can also see the faulty formula I currently have in place.

Any help would be greatly appreciated, thanks!

- Rob

2. ## Re: Identifying Duplicate Values (2nd, 3rd, and 4th occurance)

In D2 put

=IF(COUNTIF(\$B\$2:B2,B2)=2,"Second Account Mailing",IF(COUNTIF(\$B\$2:B2,B2)=3,"Third Account Mailing",IF(COUNTIF(\$B\$2:B2,B2)=4,"Fourth Account Mailing","")))

and drag down.

daffodil example for montoro22.xlsx

3. ## Re: Identifying Duplicate Values (2nd, 3rd, and 4th occurance)

Enter this formula in D2 and copy down the column.

Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)