Comparing data across multiple columns and rows
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!!
|