An Excel add-in by brettdj to manage Excel duplicates
(For Excel 2000 & higher versions)

Works with cells or entire rows
Runs over ranges, multiple sheets or the entire Workbook

V1.4 fixes & tweaks

added remove row feature to totally remove row not just contents
fixed glitch where Select option could potentially run across multiple sheets when 'Application Scope' = Range
fixed issue where the first Duplicate (cell or row) was deleted if 'Application Scope' exceeded one worksheet

Example Stuff

Highlight duplicate cells or rows
Delete duplicate cells or rows
Select duplicate cells or rows
Extract unique cells or rows to a master list
Extract and count the number of duplicate cells or rows to a master list
Run a row match on any number of columns

The file

And if it really helped ...

Thanks to the following people for their support - much appreciated :)

Tom Webb
Zack Barresse
John Fistere
Kevin Prescott
Ramon Flores
Michael Bernot
Neil Berman
William Eckman
Adam Chater

Bmedia Online Services
Parham Akhavan
Richard McCarty
Michael Caspi
Zameer Minhas
Danny Sabciyan
Travis Dultz
Bob Neil

Installing The Duplicate Master

Press the Download File! button to copy Duplicate Master.zip to your PC
Extract The Duplicate Master.xla and Duplicate Master.chm to a directory on your computer.
Start Excel, and from the Tools menu, select Add-ins and then Browse to the directory where you saved The Duplicate Master.xla. Select The Duplicate Master.xla and press Ok.
In the Add-Ins dialog box, place a check mark next to The Duplicate Master. Click OK.
Excel will now display a new command under the Tools menu, The Duplicate Master V1.4.

The Duplicate Master UserForm screenshot

Highlight duplicate cells or rows

Source Data - Cell Search	Highlight Duplicates- Cell Search
Source Data - Row Search	Highlight Duplicates- Row Search

Delete duplicate cells or rows

Delete Data (subsequents only) - Cell Search	Delete Data - Cell Search
Delete Data (subsequents only) - Row Search	Delete Data - Row Search

Select duplicate cells or rows

Select Duplicates (subsequents only) - Cell Search	Select Duplicates (all) - Cell Search
Select Duplicates (subsequents only) - Row Search	Select Duplicates (all) - Row Search

Extract unique cells or rows to a master list

Extract Unique List - Cells	Extract Duplicate List - Cells

Extract and count the number of duplicate cells or rows to a master list

Extract Unique List - Rows

Extract Duplicate List - Rows

Run a row match on any number of columns

Using the Duplicate Master for a Partial Column Match

The Duplicate Master can also be used to find partial Column matches (i.e. match rows based on Columns A, D:E), not just single cells or entire rows.
The example below runs a Highlight on Rows across a sheet called "Main". The row is highlighted only if both Columns B & D are a valid match.

There are two steps to set up a partial column match

Search Option set to Row Search
Application Scope set toRange

brettdj November 2005

Experts Exchange Profile: http://www.experts-exchange.com/M_770818.html
Linked in Profile: http://www.linkedin.com/profile?viewProfile=&key=2996376