If you work in Accounts Payable, check out the great resources at https://www.ap-now.com/. Today’s question from a recent webinar that I did for the AP-Now members: Given an Excel worksheet of payments made by accounts payable, how can you look for duplicate payments.
My solution involves the new TEXTJOIN function, the Mark Duplicates feature in Conditional Formatting, and then Filter by Color.