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).
|
|
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!
| |