Results 1 to 2 of 2

Thread: Check for Duplicate Rows in Mulitple Column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2015
    Location
    Ohio
    Posts
    166
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Check for Duplicate Rows in Mulitple Column

    A B C D E F G H I Result
    1 Matt Tim Joyce x x x x x x Dup
    2 Kyle Joyce Tim x x x x x x Unique
    3 Joyce Matt Tim x x x x x x Dup
    Hello,

    I have 9 columns A:I, and have around 2 rows 1 - 21. In each of these cells there I a name. Row 1 = Group 1, Row 2 = Group 2, etc. What I am trying to accomplish is to look in all the Groups/Rows and determine if there are two Groups/Rows that have the same 9 people in it. The think here is, there will never be any sorting of names, it is all random. So "Matt" can be in Row 1 Column B, but then can also be in Row 2 Column D...

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,659
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Check for Duplicate Rows in Mulitple Column

    Maybe:

    ABCDEFGHIJ
    1Name1Name2Name3Name4Name5Name6Name7Name8Name9Check
    2MattTimJoyceAlyceBobCherDanEssyFredDupe
    3KyleJoyceTimAlyceBobCherDanEssyFredUnique
    4JoyceMattTimAlyceBobCherDanEssyFredDupe

    Sheet5



    Worksheet Formulas
    CellFormula
    J2=IF(SUMPRODUCT(--(MMULT(COUNTIF(OFFSET(A$2:I$2,ROW(A$2:A$4)-ROW(A$2),0),A2:I2),{1;1;1;1;1;1;1;1;1})=9))>1,"Dupe","Unique")



    I put in different names because this won't work right if you have duplicate names within the same row.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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