Technical Support

Find and Remove duplicated rows in Excel

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail, or fill the Technical Request form on the Spreadsheet Tools website.

We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare here.

We've created a F.A.Q section on our website. It contains answers to the most common questions we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic

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: