Find & remove duplicates, similar records in Microsoft® Excel®

Fuzzy Duplicates Finder for Microsoft® Excel® - finding and removing duplicates in worksheets

Fuzzy Duplicate Finder for Microsoft® Excel®

For Microsoft Excel 2010, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

Fuzzy Duplicate Finder in Excel (enlarge)

If you have Microsoft Excel worksheets and workbooks with similar records that probably differ in 1 or a few characters, try Fuzzy Duplicate Finder for Microsoft Excel to handle them.

With Fuzzy Duplicate Finder plug-in you can quickly and easily find and remove partial, or fuzzy duplicates, typos, misspelled words and similar records in Microsoft Excel worksheets within a list or a selected range. Fuzzy Duplicates Finder performs a fast search for duplicates that differ in 1 to 6 characters (omitted, excess or mistyped symbols).

You specify the number of possible typos, run the add-in and see all found duplicates at a glance.

Search results are displayed in a list structured by duplicate groups. You can easily do all possible corrections: remove duplicates, set the right value to all or some duplicates automatically, or correct some of the found fuzzy duplicates manually.

With Fuzzy Duplicate Finder you can:

• Quickly find and remove all similar records, typos and misspelled words in Microsoft Excel worksheets.
• Specify the number of different characters for a particular search (from one to six omitted, excess and mistyped symbols).
• Search for fuzzy Microsoft Excel duplicates in a whole list, a column or a selected range.
• Have all found fuzzy duplicates in a list grouped by duplicate nodes.
• Make all possible corrections in the search results: removing records, setting the right values, etc.
• Correct all or some fuzzy duplicates in Microsoft Excel automatically or manually.

Fuzzy Duplicate Finder for Excel is compatible with

• Operating System: Microsoft® Windows Vista® (x32, x64), Microsoft Windows® 2003, Windows XP, 2000.
• Microsoft Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.

Finding fuzzy duplicates - Five easy steps

Open the Fuzzy Duplicate Finder pane by doing one of the following:

• Click on its icon
• Go to Excel menu -> Ablebits.com -> Fuzzy Duplicate Finder (in Excel 2003 - 2000 only).
• Press the Ctrl+Shift+F hotkey.

1. If you search for fuzzy duplicates in a sing le column, just place a cursor on any cell of that column. To search within several columns or any block of cells, just select them.
2. On the Fuzzy Duplicates Finder pane, on the Max number of different characters slide bar, set the maximum number of characters the entries may differ in (from one to six characters).
3. If you want to exclude one or several topmost rows from the search range (if the search range has column headers/names), check the Exclude header rows checkbox. You can specify the number of excluded rows in the Header rows count field.
4. Click on the Find Typos button.
5. All found items will be shown in a list grouped by duplicates (nodes). At the low-right corner of the add-in pane you can see the total number of found duplicates.

See Next - correcting fuzzy duplicates

• Setting the right value to all items of the duplicate group (node).
• Setting the right value to some items of the node.
• Correcting one item of the node.