I have one set of invoice #'s and the subtotal $ amount associated with that invoice # (2 columns of data) from one accounting software program and another set of invoice #'s and subtotal $ amounts from another accounting software program.
So, Column A = invoice #'s from quickbooks
Column B = the subtotal $ amount associated with the invoice # in the same row in Column A
Column D = invoice #'s from shopworks
Column E = subtotal $ amounts associated with the invoice # in the same row in column c
I need to find out the following
-- which invoice #'s are in Column A that aren't in Column D
-- which invoice #'s are in Column D that aren't in Column A
-- for invoice #'s that are in Column A and also in Column D, which of these have subtotal amounts that don't match up.. (for example: if invoice #15113 appears in column A and D, but the subtotal amount associated with 15113 is different in column B and column D, I need to know the invoice # of the discrepancy so I can investigate discrepancy.)
Solved by E. Y. in 20 mins