Remove duplicate rows which contain the same phone number and email address multiple times.

[nickkmal]

I get a spreadsheet with many duplicates. Some duplicate data is in one column (phone number column), some are in another (email address column).

I would like to find a way to identify the multiple rows where BOTH the phone number column data is duplicated and email address column data is duplicated with the same data. For example, where both the phone number column AND email address column are duplicated in - for example - 15 rows.

I only need one of these rows, not more.

This will allow me to remove duplicate rows which contain the same phone number and email address.

So in example below rows 3 and 4 are not duplicated. I am looking to find the other rows, and remove all but one of them

08001234833		cysvbdfler@gmail.com
08001234833		cysvbdfler@gmail.com
03303800157		cysvbdfler@gmail.com
08001234833		wecedep373@flowminer.com
08001234833		cysvbdfler@gmail.com
08001234833		cysvbdfler@gmail.com
08001234833		cysvbdfler@gmail.com
08001234833		cysvbdfler@gmail.com

 

[BSALV]

you have an excel function named "Remove duplicates" in the ribbon under "data"
you select the columns you want to check for duplicates and start ...

 

[airforceone]

will this help? array(,,,) are your column number ie. A = 1, etc...

Cells.RemoveDuplicates Columns:=Array(1, 3), Header:=xlYes

 

[nickkmal]

you have an excel function named "Remove duplicates" in the ribbon under "data"
you select the columns you want to check for duplicates and start ...

Thank you but I only want to remove where data in one row and in 2 different columns on that row are duplicated elsewhere in the sheet

 

[BSALV]

that's the function "Advanced filter"
this is the VBA version, but you can do it manually too...

  Range("A1:E25").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("J1:K1"), Unique:=True

Map2 (version 1).xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	telephone	B	C	D	email					telephone	email
2	2				row2@gmail.com
3	3				row3@gmail.com
4	4				row4@gmail.com
5	5				row5@gmail.com
6	6				row6@gmail.com
7	7				row7@gmail.com
8	8				row8@gmail.com
9	9				row9@gmail.com
10	10				row10@gmail.com
11	11				row11@gmail.com
12	12				row12@gmail.com
13	13				row13@gmail.com
14	2				row2@gmail.com
15	3				row3@gmail.com
16	4				row4@gmail.com
17	5				row5@gmail.com
18	6				row6@gmail.com
19	7				row7@gmail.com
20	8				row8@gmail.com
21	9				row9@gmail.com
22	10				row10@gmail.com
23	11				row11@gmail.com
24	12				row12@gmail.com
25	13				row13@gmail.com
Blad120

Cell Formulas
Range	Formula
A2:A13	A2	=ROW()
E2:E13	E2	="row" & ROW() & "@gmail.com"

 

[nickkmal]

Thanks so much will give that a go