Find and Remove duplicated rows in Excel

Find and remove Duplicates

This command is applicable for tables you store in Excel workbooks. If you have 2 tables with similar data, xlCompare can find and remove duplicated rows.

Find, Remove diplicates in Excel

On the screenshot about you see 2 tables with some rows on the right worksheet, highlighted with green color. These rows doesn't have matched items on the left worksheet.

To remove duplicated rows (without highlighting) use the Remove Duplicates button on the toolbar. It is active on the screenshot above.

Please, note This command is visible on the toolbar ONLY when you select worksheet node or node under the worksheet - row, cell, grouping ...

See Also: