Technical Support

Find duplicated rows in Excel

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail support@SpreadsheetTools.com, 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 Duplicates in Excel worksheet with xlCompare

This command is applicable for tables you store in Excel workbooks. If you have 2 tables with similar data, xlCompare can find duplicated rows. As a result of this operation you receive exactly the same rows on both worksheets.

Find 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 get only duplicated rows (without highlighting) use the Find 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: