Hello,
New member here. Thank you all ahead of time for your assistance.


I am attempting to compare data across multiple columns and rows. I attached some example data. I am attempting to reconcile debits and credits that have the same date. I may have the same credit/debit amount with a different date so using conditional formatting doesn't work. Ideally, I would like to have an IF statement that would check for a matching date in column A, and then look for matching numbers in columns B & C. In my example data I would like a return of "Match" in column D if there is a match. No Match can be blank. I am dealing with thousands of lines of data, so identifying a one off of no match is daunting without some automation. I've been working on this for several days without luck.
Thanks!!

Attached Files

Sample Data.xlsx (9.1 KB, 9 views)

The example file data does not show any matching Debit or Credit with different dates.

To assist you in getting the help you are requesting, please provide an example of "AFTER" ... what it would look like after the data has been processed.

Thanks.

See attached spreadsheet.

I made it a table and added a Reconciliation column to show where the daily total doesn't equal zero. Then the conditional formats applied to each column show the problem days in orange and problem transactions in red.

Attached Files

Sample Data.xlsx (21.4 KB, 9 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Columns E and F in the attached show pairings, if there might be more than one they are listed.
Separately a table to right-click and refresh at cell H1.

Attached Files

msofficeForums47925Sample Data.xlsx (20.2 KB, 10 views)

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!

Attached Files

Sample Data.xlsx (10.2 KB, 8 views)

In the attached formula in column H.
You can see the steps used to building the formula in hidden columns E:G, but these columns aren't needed at all.
There's a comment in cell H47.

Attached Files

msofficeforums47925SampleData_v2.xlsx (17.3 KB, 7 views)