I have two lists. Each have 3 columns. First Name, Last Name, Email Address

I can take the one workbook list, and add into the other to have one large list.

1. I would like to highlight all the rows that have identical data.
I'm using Excel 2007. I found a way to Highlight duplicates, but it only does it for one column (works great when highlingting duplicate emails). However, sometimes there are no email addresses listed, so I want to see the first & last name combo duplicates.

Example: (Both would count as a duplicate)
Ricky Henderson User@domain.com
Ricky Henderson User@domain.com
John Smith (Blank)
John Smith (Blank)

2. I would like to then count how many duplicates there are. (Above example being 2 duplicates)


3. I then would like to have an option to delete all the duplicates.

This would allow me to see who is duplicated, know how many were duplicated, and delete the duplications.

Ill take an add-in, macro forumula, any suggestions you have. Thanks for the help!