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
Highlight the results you need and ignore rest
Let's imagine common task - you have 2 lists of data and you need to separate records which are unique in both lists.
xlCompare offers you quick and flexible solution. In a few seconds (time depends on the size of your spreadsheet) you'll get 2 lists of records.
See below which steps you need to do:
1. Compare your spreadsheets and get Difference Explorer window with comparison results.
2. Apply Filter | Exclude Duplicates command:
Done!Now you have filtered (only red and green) records on the screen.
Note!Records are filtered only! They are not removed phisically from the workbook. Just hidden. When you close Difference Explorer they are restored.
Now you can select records and copy them.
Now let's imagine another case - you need to leave only red and green rows on the sheets
1. First step is the same - Compare your spreadsheets.
2. Apply Remove Duplicates command:
Done! Now you have ONLY red and green records on the sheet. All other records were removed.