I am trying to reconcile 2 xl files and need to generate two lists of items
not included on the other worksheet. ie. On file 1 not on file 2, and, on
file 2 not on file 1.
Both files have two colums. Column A is a 6 digit number and column B is a
dollar value. Both files have in excess of 10,000 rows. List of reconciling
items needs to show data from both columns.
Both files can be merged to the same worksheet if this simplifies the
solution.
I have used VLOOKUP and filtered by #N/A and then cut and pasted visible
cells to create my list but was hoping for a simpler solution.