FIG. 03ACCOUNTANT · EXCEL
Two lists that have to tie
Two lists are supposed to describe the same things, and they do not.
Recording
The rows that tie, and the rows that do not.
- 01
Put both lists in the workbook, one sheet each.
- 02
Ask Excelsior to match them and show what is only on one side.
- 03
Tell it not to treat similar names as the same row unless you say so.
- 04
Check the counts. What remains is what you have to explain.
The rows that tie, and the rows that do not.