I've read a lot of the other entries on finding duplicates but I'm after something slightly different. I've got a customer list, where the email address is used as the primary key, and this list has records of every customer contact with the reasons for contact.
As it's now a large file with around 35k records, can anyone recommend a way that I could identify the multiple contacts (preferably in another column).
My ideal is the first entry says "first contact", the second entry "second contact" and so on, so the repeat contact customers can be easily found.
Any ideas??
As it's now a large file with around 35k records, can anyone recommend a way that I could identify the multiple contacts (preferably in another column).
My ideal is the first entry says "first contact", the second entry "second contact" and so on, so the repeat contact customers can be easily found.
Any ideas??