Copy / Move Duplicate Entry

[DaRTH KiRo]

I am kind of just brainstorming here. I have a massive list of contacts that I am try to clean to the best of my ability before handling an import. I have Account Numbers in column A and First / Last in B & C, column D are phone numbers & column E are extensions, and finally column F is the email address. Would there be a way to compare Account Numbers and email addresses and when it hits a duplicate of both it moves the value from D, or maybe even D & E, into Column H? I am running into contacts that have multiple phone numbers and I cannot be sure which is accurate and I would like to not have to delete them. I believe I may be able to doctor something up on my own (maybe?) if it was only just one duplicate but there are times where one account number could have two or more duplicate email addresses (due to multiple phone numbers). The columns would be sorted so that the emails are in alphabetical order and then the account numbers would be sorted from smallest to largest so technically all matching email addresses for the specific account number would be together.

If you are reading this, thank you for your time! This forum saves me so much time and manual work!

 

[Brunts]

Create two additional columns - first one concatenating the Account Number and email address and the second one, a countif, counting how many occurrences of the concatenated Account Number and email address values are in your massive list, then you can filter them, where the contif value is greater than 1 and take whatever your next step is to verify values

Excel Forum.xlsx
	A	B	C	D	E	F	G	H
1	Account Numbers	First	Last	Phone Number	Extensions	email address	Concat	Count
2	123456	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel1@Excel.com	123456mrExcel1@Excel.com	1
3	123457	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel2@Excel.com	123457mrExcel2@Excel.com	1
4	123458	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel3@Excel.com	123458mrExcel3@Excel.com	1
5	123459	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel4@Excel.com	123459mrExcel4@Excel.com	1
6	123460	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel5@Excel.com	123460mrExcel5@Excel.com	2
7	123460	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel5@Excel.com	123460mrExcel5@Excel.com	2
8	123462	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel7@Excel.com	123462mrExcel7@Excel.com	1
9	123463	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel8@Excel.com	123463mrExcel8@Excel.com	1
10	123464	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel9@Excel.com	123464mrExcel9@Excel.com	1
11	123465	Doesn't	Matter	0131 123 4567	Irrelevant	mrExcel10@Excel.com	123465mrExcel10@Excel.com	1
Sheet6

Cell Formulas
Range	Formula
G2:G11	G2	=A2&F2
H2:H11	H2	=COUNTIF($G$2:$G$11,G2)