4. What can I do with Comparison Results?
This topic describes additional benefits of xlCompare, you get with comparison report.
4.1. Filter unique, equal and duplicate rows
xlCompare.com has number of commands to filter the comparison report and get only the portion of rows you need.
Click on the Added Rows item in the Legend.
xlCompare provides you a list of added rows, highlighted with green color.
To get the absolutely identical rows between two Excel tables - click Equal Rows item in the Legend area.
As you see, xlCompare.com in more than just an Excel file comparison tool.
This is reliable and powerful toolkit that works for you!
4.2. Get all differences as single list
Need to review all the differences as single list?
Or you need to forward this data to colleague by email?
REPORT area displays list of differences on the left side of the FILE 1 area.
When you select a cell in this table, xlCompare.com selects corresponding cell in the comparison report to point you to the difference.
4.2.1. How to copy this list into email?
Click on the any cell in the Difference Report area.
Press Ctrl+A to select the entire report.
Right click on the any cell.
Select Copy element in the context menu.
Now this table is in clipboard and you can paste it into the any application - email, Excel, Word, etc.
4.3. Copy report to save it on your computer
COPY command in the Legend area is a universal method to export the comparison report.
It copies Comparison Report with all highlighted cells into the clipboard in HTML format.
You can paste it into Excel worksheet to save the data on hard drive or in the cloud for future processing.
Save Report button saves the comparison report on disk in the presentation form. Use this command to save report as a file and send it to colleague.