I have been reading this thread and it appears to be close to what I am
trying to acheive. Could you possible amend your formula for me?

I have lots of duplicate contacts in Outlook and have run a "remove
duplicates" app which does just that; it removes duplicates! What I really
need is to merge duplicate contacts where there is different data in
different fields. I have exported the data into excel and now have one set
of headers for all contacts but within the rows of contacts I have some
duplicates. One entry might have the mobile number but not the email address
the other might be the reverse of this. What I need to do is to merge rows
where duplicates occur (maybe using the surname and forename as a point of
reference) and so end up with one entry that has a full set of data.

Could you help with this please?

Many thanks

Andrew

"Bob Tarburton" wrote:

Perhaps you should e-mail me a sample sheet showing that the formula isn't
working.
Just delete the "_removethis_" part from my email. Post a message if you do
so I know to look for it.


=IF(ISNA(MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000 ="Mail"),0),0)),IF(ROW(A2)-1=MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000="Home" ),0),0),"Keep","Duplicate"),IF(ROW(A2)-1=MATCH(1,INDEX((A$2:A$5000=A2)*(C$2:C$5000="Mail" ),0),0),"Keep","Duplicate"))