+ Reply to Thread
Results 1 to 2 of 2

Find duplicate values based on 2 separate columns

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Find duplicate values based on 2 separate columns

    I need a formula that compares the values of 2 different cells in 2 different columns (same row) to see if there are duplicate values in the array, with those same 2 values. I could easily do this by concatenating the 2 values and running a countif to see if there is more than 1 instance of it, but I don't want to do that. I have one pre-defined column that I need this formula to go into, so I want one formula that does this.

    I cannot use vba, conditional formatting, filtering, etc.. on this. It needs to be one self-contained formula. (The spread sheet it will go into; there's hundreds of them, thousands of rows, etc... I just need something to quickly identify the duplication with no additional work for the user.)

    I just need to know if those two values together both duplicate somewhere else in my spreadsheet; the number of times duplicated is not an issue.

    I.E.
    I have columns A and B.
    Column A has 30 values, numbered 1, 2 and 3, ten duplicates each. Column B has random dates. I want to know if any of those rows contain both a matching date and a matching group number. If 1/1/2013 appears 3 times and is in groups, 1, 2, and 3, then I don't care. If it appears 3 times, all in group 3, then I want to identify those.

    Any suggestions/solutions would be most appreciated. Thanks!

    Book1.xlsx
    I added a sample workbook, if this helps. The ones that I highlighted are the ones that I would want the formula to catch; where both cell values are the same.
    Last edited by dreich; 01-30-2013 at 12:29 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Find duplicate values based on 2 separate columns

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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