Results 1 to 10 of 10

How to find duplicate invoices when the duplicate may contain a letter?

Threaded View

  1. #8
    Registered User
    Join Date
    01-23-2012
    Location
    toronto
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to find duplicate invoices when the duplicate may contain a letter?

    Hmm, this isn't doing as much as I thought it would.

    Might have to start over here. Currently I have a pivot table with the following information.

    Vendor Invoice# GL Account Total

    How would I find duplicate invoices here, even if the invoice may contain an extra letter?

    Would I find just use a countif formula to find duplicates of invoice, gl account, total, and one that runs to see if there is an invoice with an extra letter?

    After this is done and say I want to pull out entries that have duplicates of invoice, gl account and total, how would I do that?
    Last edited by foz; 01-30-2012 at 10:56 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1