Check for Duplicate Rows in Mulitple Column

[kparadise]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Matt
[/TD]
[TD]Tim
[/TD]
[TD]Joyce
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]Dup
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Kyle
[/TD]
[TD]Joyce
[/TD]
[TD]Tim
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]Unique
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Joyce
[/TD]
[TD]Matt
[/TD]
[TD]Tim
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]Dup
[/TD]
[/TR]
</tbody>[/TABLE]
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...

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Name1	Name2	Name3	Name4	Name5	Name6	Name7	Name8	Name9	Check
2	Matt	Tim	Joyce	Alyce	Bob	Cher	Dan	Essy	Fred	Dupe
3	Kyle	Joyce	Tim	Alyce	Bob	Cher	Dan	Essy	Fred	Unique
4	Joyce	Matt	Tim	Alyce	Bob	Cher	Dan	Essy	Fred	Dupe
Sheet5

Cell Formulas
Range	Formula
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.