Duplicate payments
Ten invoices were paid twice, and most of them are disguised. Five COUNTIFS tests find every one, even when the invoice number, the date or the vendor record was changed.
- The exact duplicate
- Ignore the invoice number
- Clean the invoice number
- Same invoice, different vendor
- Paid close together






