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
Filter cells on the Excel worksheet with xlCompare
Compare 2 worksheets and get the results is only a part of the services offered by xlCompare. When you see results in the Difference Browser next step is to work with them - validate, format, edit, add comment or smth else. This job will not be complete without Filter feature.
On this screenshot we've highlighted button which executes Filter command. But please note, it is applicable only to the worksheets. If you've compared smth else - VBA Modules or Forms - there is nothing to filter.
Filter command allows you to see only duplicated data, or only changed cells, or exclude duplicates and display only "new" data.
Now try to run this command - you are getting this window:
We allow to select one of the predefined filters. Now we'll display them in detail:
Changed cells. If you have a large worksheet you don't see all changed cells (highlighted with yellow color) on the screen. This filter allows you to get only changed data on your screen. So, you can see what was actually changed.
New cells (added and deleted rows). This filter has another explanation - exclude duplicates. All duplicates in the comparison report are not marked at all (equal rows) or appear as changed rows (when key is the same, but something in row was changed). This filter allows you to hide duplicated rows (key is present on the both sheets) and display rows which doesn't have corresponding items on the another worksheet.
When filter command is applied, it's button is marked with red color. This means that filter is active. To stop filtering and display all data again, you should use Cancel Filter button on the Filter Window.