+ Reply to Thread
Results 1 to 4 of 4

comparing multiple columns for duplicates

  1. #1
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    comparing multiple columns for duplicates

    I am trying to find duplicates between two worksheets where there are three column comparisons. I have attached an example.

    In the "Manual" the two red entries are also found on the Computer tab.

    Is there a formula I can use to either do a conditional format or flag for duplicates? Example12-6.xlsx
    Last edited by shuddle; 12-20-2011 at 12:09 PM.

  2. #2
    Registered User
    Join Date
    12-01-2011
    Location
    Peterborough
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: comparing multiple columns for duplicates

    Please see attached spreadsheet, the manual page now tells you if they match or don't match.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    Re: comparing multiple columns for duplicates

    The attached is a league stats workbook. Please reattach the correct workbook.

  4. #4
    Registered User
    Join Date
    06-06-2008
    Posts
    39

    Re: comparing multiple columns for duplicates

    Never mind. I figured out a way to use Concatenate and Count If to make it work.

+ Reply to Thread

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