Hi all,

Hoping you can help me here, I'm no expert in excel.

I have a query of about 16,000 invoices based on what I consider possibly important..

-Date
-Invoice Number
-Amount
-Vendor
-GL acct

The problem is A/P clerks will sometimes add a letter to the invoice to bypass the internal control (won't allow you to enter duplicate invoices), so there may be an invoice #240 and #240a and they both end up getting paid but really it's only 1 invoice. What would you suggest in order to find these?

Thanks for any input!