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
Bookmarks