Comparing values of cells (cells in the same relative position) in two tables.
- It compares the values of the cells in the same relative positions. Comparing is smart,
so (for example) 100% = 1!
Dates are compared differently than numbers. (For Excel each date is just a number!).
- You can compare tables on the same sheet, on different sheets or even on different workbooks!