|
|
#5
11-09-2021, 04:51 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
| Transpose multiple data form rows in columns matched with a key | Alex1s85 | Excel | 6 | 06-24-2020 07:08 AM |
 How to Loop through rows and Columns to Offset Data
|
Josh1012 | Excel Programming | 4 | 09-06-2018 03:20 AM |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
| macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
Windows 10 
Office 2019
Threaded Mode