Finding Duplicate entries (yes, another one)

[BlockFunk]

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??

 

[Norie]

So you have two columns - one with the email address and one with the reason for contact?

And you want to change that so you have one column for the email address and a column for each reason for contact?

Can you post a small example of what you have and what you want?

 

[BlockFunk]

The format is as follows now (three columns)

Email Reason Contact Date

Fred@abc.com Payment xx/xx/xxxx
Bill@abc.com Products xx/xx/xxxx
Fred@abc.com Payment xx/xx/xxxx
Dave@abc.com Credit xx/xx/xxxx
Sean@abc.com Credit xx/xx/xxxx
Fred@abc.com Payment xx/xx/xxxx

What I want to do is for a formula or array to be added to the table in a new column (or a separate linked worksheet) that will show in a new column the repeated cases. i.e.

Email Reason Contact Date Repeat?

Fred@abc.com Payment xx/xx/xxxx First Contact
Bill@abc.com Products xx/xx/xxxx First contact
Fred@abc.com Payment xx/xx/xxxx Second contact
Dave@abc.com Credit xx/xx/xxxx First contact
Sean@abc.com Credit xx/xx/xxxx First contact
Fred@abc.com Payment xx/xx/xxxx Third contact

It needs to take account of the contact date to be suitable, is that clearer?

 

[2rrs]

The format is as follows now (three columns)

Email Reason Contact Date

Fred@abc.com Payment xx/xx/xxxx
Bill@abc.com Products xx/xx/xxxx
Fred@abc.com Payment xx/xx/xxxx
Dave@abc.com Credit xx/xx/xxxx
Sean@abc.com Credit xx/xx/xxxx
Fred@abc.com Payment xx/xx/xxxx

What I want to do is for a formula or array to be added to the table in a new column (or a separate linked worksheet) that will show in a new column the repeated cases. i.e.

Email Reason Contact Date Repeat?

Fred@abc.com Payment xx/xx/xxxx First Contact
Bill@abc.com Products xx/xx/xxxx First contact
Fred@abc.com Payment xx/xx/xxxx Second contact
Dave@abc.com Credit xx/xx/xxxx First contact
Sean@abc.com Credit xx/xx/xxxx First contact
Fred@abc.com Payment xx/xx/xxxx Third contact

It needs to take account of the contact date to be suitable, is that clearer?

You could try something like this:

="Contact # "&COUNTIF($A$2:A35000,A2) and fill down.

this will return Contact # 1, Contact # 2, Contact #..... for each email address.