One of the common tasks of the Excel users - filter matching rows on two Excel worksheets and find updated cells in the matching rows.
xlCompare easily does this job. If you have your worksheets compared, it is very easy to introduce you matching records.
xlCompare give you ability to extract these records from the worksheet and to save them as another file.
![Filter changed cells and inserted rows in Excel Compare](./images2/img-7-15.webp)
Filter matching(duplicate) rows on two Excel worksheets
xlCompare gives you set of filtering commands. Use Matching rows command to get only rows that have corresponding row on the other worksheet.
Get unique rows in two Excel files
Use Filter | Unique Rows command on the Ribbon, and xlCompare will show you only rows that doesn't have the matching item on the other sheet.
Get completely equal rows on two Excel worksheets
Filter | Equal Rows command leaves only identical rows on your screen
Save filtered rows you need on disk
After you've filtered rows you need, use Save | Only Visible Rows command from the right click menu on this sheet. This is quick and easy way to save filtered data in the other file.