tools

wizards

step by step

faq

download

MExcel

..:: Compare tables

Wizard - first step ::..

In the first step you select both tables (tables that you wish to compare) and the type of comparison (if you wish to compare values or formulas).
All steps Second step

Values...

  • MExcel compares values not formats of the cells. This is important difference because by comparing values MExcel will know that 1 and 100% is the same value even if the format is different.
  • Dates and times are compared differently than numbers, regardless of the fact that, for Excel, every date or time is just a number.
  • You can compare tables on the same sheet, on different sheets or even on different workbooks!

Formulas...

  • Formulas are compared with some logic and relative to table.
  • You can compare tables on the same sheet, on different sheets or even on different workbooks!