Comparing Rows. 1

[jatolo]

1 2 3 4 5 6 7 8 9 10
joe Doe A C B C C A B A A C
John P. C B A A A C B B C B
MARY S. A C B B C C A A B C

I have about 60 persons with diferents scores(A,B,C)in 10 games...
Is there any way to find out if two persons has chosen the same scores.....coincidentally.
Thanks very much!!!


Thanks....
Jatolo

 

[SkipVought]

Hi,

Your data would be much easier to analyze if it were normalized. That's the way Excel works the best.

faq68-5287

Your NORMALIZED data
[tt]
Player Game Value
joe Doe 1 A
joe Doe 2 C
joe Doe 3 B
joe Doe 4 C
joe Doe 5 C
joe Doe 6 A
joe Doe 7 B
joe Doe 8 A
joe Doe 9 A
joe Doe 10 C
John P. 1 C
John P. 2 B
John P. 3 A
John P. 4 A
John P. 5 A
John P. 6 C
John P. 7 B
John P. 8 B
John P. 9 C
John P. 10 B
MARY S. 1 A
MARY S. 2 C
MARY S. 3 B
MARY S. 4 B
MARY S. 5 C
MARY S. 6 C
MARY S. 7 A
MARY S. 8 A
MARY S. 9 B
MARY S. 10 C
[/tt]
Here is the PivotTable result...
[tt]
Count of Value
Value
Game A B C
1 2 1
2 1 2
3 1 2
4 1 1 1
5 1 2
6 1 2
7 1 2
8 2 1
9 1 1 1
10 1 2

[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}