NickUpstream
New Member
- Joined
- Sep 10, 2014
- Messages
- 2
Hi everyone,
Having a nightmare here - i'm no excel wizard by any means.
Situation: I have a list of customers on our CRM Database. I have a list of customers on our e-mail marketing list.
I have: Amalgamated these lists, side by side - (company, Contact, E-mail, First Name, Last Name).
What I have to do: Need to delete every duplicate record and original record (If nick@mrexcel.com exists on CRM list and E-mail Marketing List = Delete)
What I have do: I used the COUNTIF function locate the duplicate records. Every duplicate now has a 1 or 2 next to them.
Now what: Now I have located the duplicates; how do I go about deleting both original and duplicate from the lists?
Thanks in advanced, the above took me HOURS!
Nick
Having a nightmare here - i'm no excel wizard by any means.
Situation: I have a list of customers on our CRM Database. I have a list of customers on our e-mail marketing list.
I have: Amalgamated these lists, side by side - (company, Contact, E-mail, First Name, Last Name).
What I have to do: Need to delete every duplicate record and original record (If nick@mrexcel.com exists on CRM list and E-mail Marketing List = Delete)
What I have do: I used the COUNTIF function locate the duplicate records. Every duplicate now has a 1 or 2 next to them.
Now what: Now I have located the duplicates; how do I go about deleting both original and duplicate from the lists?
Thanks in advanced, the above took me HOURS!
Nick