Hi,
I am trying to come up with a formula to match off data but not having much luck. I am trying to match credit card (cc) transactions to the general ledger (GL). I combine these two pieces of data into one file, where the cc transactions show as a positve and the GL entries as a negative number. The data includes the date of the transaction, a unique identifier (which relates to an individual), and the amount. I envision a forumla that will match the cc transactions and the GL by marking an "x" or something. All of the "x" rows will add to zero and the remainig rows will be the outstanding transactions that do not match. One other caveat is that there may be multiple GL transactions that add up to the cc transaction. They will occur on the same day and have the same unique identifier though. For example, there may be a $142 cc charge (positve) that is offset by two $71 GL charges (negative). I will attach a sample file. In the sample, column D is how I would prefer the output to look but if you have a better way, I'm open to suggestions.