Compare for Differences (Compare2/Uniques)

This action can highlight and place tags within the sources being compared and it can also generate a new worksheet that holds a report.

Select two areas of the worksheet to compare against each other for differences. Use this feature for determining what is within one list (or document) that is not within another list (or document) regardless of row ordering. The differences will be revealed and a report can be generated. Whole rows, partial rows, or comma delimited items can be compared among areas selected. For example, use it to find the differences between two bills of materials or two printed circuit board Netlists. The sequence of each of the two lists is not considered — no differences will be reported as as long as everything in one list is present somewhere within the other (include sequence numbers in your lists if the lists’ sequence must be considered).

Here are some things you can do using this feature:

  • Compare full or partial rows (compare documents)
  • Compare lists of individual items (including multiple comma delimited items within single cells)
  • Paste lists of items found which are unique to each group being compared
  • Generate a new report sheet listing only differences (uniques)
  • Auto-highlight rows that do not match (uniques)
  • Tag rows with differences

Note: These added Tags can be used with Excel’s AutoFilter, or Advanced Filter, or with Excel’s Sort to view and to work among only the rows with differences. Tags can call out the unique items found within a row, and the Tags can be used to identify which of the two selected areas the difference belongs to.

Read about Refinate’s powerful Text Converter/Import to see that Refinate can convert documents while importing into Excel. That ability (in conjunction with Reduce Rows to One when needed), permits you to convert two different documents styles containing the same information into the same style so they can then be compared using Refinate’s Compare2/Uniques.