© LikeOffice.co.il

Our LikeOffice Excel Utility includes also an Excel Compare feature. It is a unique tool that lets you compare and analyze differences between two Excel tables or ranges.

It has both a Logical and a Visual comparison.

It was award prizes for its simplicity and effectiveness.

 

Excel Compare_

Visual comparison - comparing between two worksheets in a “not a smart way”, meaning it compares between cell A1 in the Base Worksheet to cell A1 in the Compared Worksheet and back and forth and so on and so forth.

Logical comparison
Comparing of two excel worksheets according to a key Field (like ID or product number etc'), located in Column A of each worksheet. The results are reported to a separate worksheets which includes the following five reports:

  • Additional Rows - meaning, what records were added to the Compared worksheet?

  • Deletions Rows - meaning, what records were deleted from Base worksheet?

  • Key Change - meaning, what records with the same Key Field were changed? What are the changes?

  • Joint Records - meaning, what are the only records that appear in both, Base worksheet and Compared Worksheet, with the same Key Field?

  • All records - meaning, what are the records that appear in either Based Worksheet or Compared Worksheet?

  • Records that appear in both Worksheets will appear only once in this reports. The information related to these records will be taken out of the Based Worksheet.

In Logical Comparison, the Key Field must be in column A in each of your excel worksheet. In addition, it is very recommended that the Key Field will be unique and no empty fields will be in column A. If it is not unique or if in column A there are empty fields, then you either have to fix your records or to continue with the comparison. Our Excel Compare will continue the comparison process taking into account these rejections.

Example: