Hi all,
I've searched through the forums but can find an example of my problem.
I have a large dataset of credit card transactions (>10,000) and I'm reviewing and I'm trying to highlight duplicates in multiple columns. Essentially I'm trying to locate transactions which have been processed with 1 day of each other at the same store, same business area and that are over a certain value ($100 in the example).
I've attached an example of my data along with expected results, any help would be much appreciated.
Thanks
David
Bookmarks