IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
xlCompare: How to find duplicates in your worksheets
This is another useful command in the worksheet processing.
For example, you have 4 lists of data stored on the Excel worksheets and need to find records which are present in all lists. You can spend whole all day on copying and pasting records from one sheet to another. xlCompare does this work in a seconds. All you need is to open workbooks you want to process and select Get Duplicates command:
When you select Get Duplicates command, xlCompare does the following:
- Find unique and duplicate records on both worksheets
- Unique records are removed from the both worksheets
Like the Merge command, this one does all work itself and gives you result in single click.
This command doesn't add color formatting, it just gives you list of records.
On image below you can see typical results on the merge command:
- Button Compare was changes to Get Duplicates
- Only unique records are present on all processed worksheets