Find and Delete Duplicates

[gibbsa08]

Hi all,

I know this is likely a trivial question but I need help creating a macro that finds and removes duplicates in two columns of data. The remove duplicates option under data only removes a single data entry. I need the macro to find both and delete the corresponding rows.

Example:

Employee ID Employee Name
1212345 Charlene Moss
141478 Guy Starry
101798497 Kalas,Jackie
101407065 ponce,jimmy Benjamin
101806578 Miller,Derrick
101644866 Dericho,Jaiva
101210576 Tice Jr,Michael Shawn
100851057 Stewart,Kiyoshi
101529933 Gonzalez,Beatriz T
101407060 Copeland,Bridgette
100897323 Tinker,Teasha
101407065 ponce,jimmy Benjamin
101806578 Miller,Derrick
1212345 Charlene Moss

Macro would remove all duplicates and the result would be:

Employee ID Employee Name
141478 Guy Starry
101798497 Kalas,Jackie
101644866 Dericho,Jaiva
101210576 Tice Jr,Michael Shawn
100851057 Stewart,Kiyoshi
101529933 Gonzalez,Beatriz T
101407060 Copeland,Bridgette
100897323 Tinker,Teasha

[Marc L]

Hi !

The way you could automate : use (SUMIF) COUNTIF worksheet function on range ID, sort the result and delete rows where result > 1 …

[rcm]

Please Login or Register  to view this content.

[bakerman2]

Try this.

Please Login or Register  to view this content.