Thanks all for the replies. I am looking for a formula that would return "M" for Match or "NM" for No Match. What I need to ultimately identify are the credits that do not have a matching debt while confirming that the deposit date is the same on both the credit and debit.
In addition:
Some matching credits and debits will not have the same deposit date. I would need the matching credits and debits that do not have the deposit date to be returned as no match.
I added an updated sample data that provides results that I an seeking and also highlighted examples of when a credit and debit match but the deposit date does not. Let me know if I need to provide additional clarification. Thanks!
Last edited by Cooper13300; 11-09-2021 at 05:03 PM.
Reason: providing attachment and additional information
|