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

1. ## 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. ## 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.

## User Tag List

#### Posting Permissions

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