Hey all,

I have two columns of data that I am trying to compare (for instance, a credit card statement expense column and a Quickbooks credit card expense column). My goal is to be able to see pretty easily which cells either did not import into Quickbooks or were imported into Quickbooks and should not have been there (i.e. which cells don't match the other column). I have been using the MATCH formula (see attached xls), but this is still a manual process because after running it for each column of data, I then have to manually add all the columns that didn't match. Also, this ignores the fact that two $50 expenses are not the same exact charge. So, if I have 3 credit card transactions that are 49.48, the MATCH formula would tell me that, as long as 1 of the transactions is in Quickbooks, then all are in Quickbooks.
Anyways, sorry for rambling, but there MUST be a better way.. Right?!
Thanks in advance, and happy to help with anybody else's quandaries.


sample_match.xlsm