xlCompare has 10+ time saving functions which were created solve the most common tasks in a seconds
Merge data between two worksheets
In single click xlCompare does the following:
- Find unique and existing records
- Update all existing records with values from the right sheet
- Mark updated cells with color
- Copy unique (new) rows and columns from right sheet to the left one
- Mark added records with color
More information on the
Merge Command ...
>Update data on the Excel worksheet
In single click xlCompare does the following:
- Find unique and existing records
- Update all existing records with values from the right sheet
- Mark updated cells with color
- Unique records are not processed
More information on the
Update Command ...
Remove duplicates between two worksheets
This command is similar, xlCompare does the following:
- Find unique and existing records
- Update all existing records with values from the right sheet
- Mark updated cells with color
- Copy unique (new) rows and columns from right sheet to the left one
- Mark added records with color
More information on the
Remove Duplicates ...
Get duplicate records between two worksheets (Intersection)
This command is to find common records between set of lists:
- Find unique and existing records
- Removes all unique records on the left worksheet
- Mark updated cells with color
- Equal values are not updated
More information on the
Get Duplicates ...
Bulk Merge commands
Merge multiple differences between workbooks in single click:
- Merge all updated records from one workbook to another
- Undo bulk merge operation
More information on the
Bulk Merge Commands ...
Filter records
xlCompare gives you ability to dislay only records you need:
- Only completely equal records
- Records with equal keys (duplicates)
- Unique records (duplicates excluded)
Sort records by key
You select a column and xlCompare sorts data on the worksheet. If your data has heading, it is found and omitted.
How to Sort Data on the worksheet
Delete Records
xlCompare has commands to remove:
- Empty rows (records)
- Hidden rows (records)
If you've got worksheet with blank rows, you can remove them in second. Also,
you can filter your data, by any criteria and apply this command to cut the
hidden data.
If you can't find a feature you need in the xlCompare, please report it to us.
We will add it as soon as possible.