Highlight (and eventually remove) duplicate information from multiple cells

[emballz55]

I know there is a lot of threads about this and I have tried to copy and follow them, but have to luck - I have no experience with macros and basic formulas only. I have a large file of nearly 70,000 rows containing college application information that needs to be cleaned to send to another data collection agency.

I cleaned out to 24,004 rows that match my criteria and now I must remove all duplicate entries. What I need to do it is find duplicate rows that contain the same last name (Column D) and date of birth (Column F), highlight them, and go back and verify by hand if they are the same person who applied under different user id or actually different people who happen to have the same name and dob. After these are verified, I need to delete them because we pay per person for the data collection!

I have already gone through and removed duplicate user id rows, however you do not have to include this and it could be imputed wrong so cannot rely only on that.

I have attached a short example of the workbook.

Thank you!

A	B	C	D	E	F
UserID	first_name	middle_name	last_name	suffix	dob
11111111	First 1	Middle 1	Last 1		1919-11-23 00:00:00
22222222	First 2	Middle 2	Last 2		1952-12-31 00:00:00
33333333	First 3	Middle 3	Last 3		1988-11-25 00:00:00
44444444	First 4	Middle 4	Last 4		1990-12-30 00:00:00
55555555	First 5	Middle 5	Last 5		1991-01-22 00:00:00
66666666	First 6	Middle 6	Last 6		1991-03-22 00:00:00
77777777	First 7	Middle 7	Last 7		1991-10-28 00:00:00
88888888	First 8	Middle 8	Last 8		1991-11-12 00:00:00
99999999	First 9	Middle 9	Last 9		1991-11-15 00:00:00
10101010	First 10	Middle 10	Last 10		1991-12-27 00:00:00
12345678	First 11	Middle 11	Last 11		1992-01-24 00:00:00
12121212	First 12	Middle 12	Last 12		1992-10-27 00:00:00
13131313	First 13	Middle 13	Last 13		1993-01-30 00:00:00
14141414	First 14	Middle 14	Last 14		1993-12-31 00:00:00
15151515	First 15	Middle 15	Last 15		1994-05-16 00:00:00
16161616	First 16	Middle 16	Last 16		1995-06-04 00:00:00
17171717	First 17	Middle 17	Last 17		1995-06-06 00:00:00
18181818	First 18	Middle 18	Last 18		1996-01-10 00:00:00
19191919	First 19	Middle 19	Last 19		1996-09-07 00:00:00
20202020	First 20	Middle 20	Last 20		1996-10-18 00:00:00
21212121	First 21	Middle 21	Last 21		1996-11-15 00:00:00
22222222	First 22	Middle 22	Last 22		1996-11-25 00:00:00
23232323	First 23	Middle 23	Last 23		1996-12-19 00:00:00
24242424	First 24	Middle 24	Last 24		1996-12-29 00:00:00
25252525	First 25	Middle 25	Last 25		1997-01-07 00:00:00
26262626	First 26	Middle 26	Last 26		1998-12-03 00:00:00
27272727	First 27	Middle 27	Last 27		1999-02-13 00:00:00
28282828	First 28	Middle 28	Last 28		2005-06-05 00:00:00
29292929	First 29	Middle 29	Last 29		2011-01-29 00:00:00
30303030	First 30	Middle 30	Last 30		2012-01-23 00:00:00
31313131	First 31	Middle 31	Last 31		2012-10-12 00:00:00
32323232	First 32	Middle 32	Last 32		2012-11-15 00:00:00
33033033	First 4	Middle 4	Last 4		1990-12-30 00:00:00
34343434	First 18	Middle 18	Last 18		1996-01-10 00:00:00
35353535	First 9	Middle 9	Last 9		1991-11-15 00:00:00

<tbody>
</tbody>