Check for Duplicate Rows in Mulitple Column

[kparadise]

	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

<tbody>
</tbody>

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.