Correlation Matrix keying on one variable

Reboshua

Board Regular
Joined
Jan 23, 2015
Messages
88
I have a dataset - see below - that shows the quiz grades of 30 students in 6 different classrooms over 5 days in February.​

I'd like to create a correlation matrix to show the relationship between these students and their grades, but I am ONLY interested in seeing correlations between kids in the same classroom. I am trying to examine whether seating arrangements in classrooms have an effect on student grades, either because kids cheat off of one another or because kids of similar abilities tend to cluster around one another, etc.

Without breaking the data table up by Teacher and then doing individual matrices for each classroom, is there a way to create a single correlation table that only correlates kids with the same teacher to one another?

Thanks!Excel 2016 (Windows) 64 bit[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A
[/th][th]
B
[/th][th]
C
[/th][th]
D
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1
[/td][td]Name[/td][td]Teacher[/td][td]Date[/td][td]Quiz Grade[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2
[/td][td]Sally[/td][td]Jones[/td][td]
2/1/2018​
[/td][td]
61​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3
[/td][td]Jane[/td][td]Anderson[/td][td]
2/1/2018​
[/td][td]
69​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4
[/td][td]Billy[/td][td]Smith[/td][td]
2/1/2018​
[/td][td]
88​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5
[/td][td]Bobby[/td][td]Hill[/td][td]
2/1/2018​
[/td][td]
93​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6
[/td][td]Alice[/td][td]Barnes[/td][td]
2/1/2018​
[/td][td]
99​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7
[/td][td]Joe[/td][td]Johnson[/td][td]
2/1/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8
[/td][td]Gary[/td][td]Jones[/td][td]
2/1/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9
[/td][td]Carol[/td][td]Anderson[/td][td]
2/1/2018​
[/td][td]
62​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10
[/td][td]Ann[/td][td]Smith[/td][td]
2/1/2018​
[/td][td]
81​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11
[/td][td]Michael[/td][td]Hill[/td][td]
2/1/2018​
[/td][td]
69​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12
[/td][td]Jessica[/td][td]Barnes[/td][td]
2/1/2018​
[/td][td]
68​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13
[/td][td]Tim[/td][td]Johnson[/td][td]
2/1/2018​
[/td][td]
82​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14
[/td][td]Peter[/td][td]Jones[/td][td]
2/1/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15
[/td][td]Cindy[/td][td]Anderson[/td][td]
2/1/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16
[/td][td]Ellen[/td][td]Smith[/td][td]
2/1/2018​
[/td][td]
96​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17
[/td][td]Martha[/td][td]Hill[/td][td]
2/1/2018​
[/td][td]
89​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18
[/td][td]David[/td][td]Barnes[/td][td]
2/1/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19
[/td][td]Matthew[/td][td]Johnson[/td][td]
2/1/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20
[/td][td]Joshua[/td][td]Jones[/td][td]
2/1/2018​
[/td][td]
77​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
21
[/td][td]Amy[/td][td]Anderson[/td][td]
2/1/2018​
[/td][td]
68​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
22
[/td][td]Tom[/td][td]Smith[/td][td]
2/1/2018​
[/td][td]
96​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
23
[/td][td]Ben[/td][td]Hill[/td][td]
2/1/2018​
[/td][td]
83​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
24
[/td][td]Alie[/td][td]Barnes[/td][td]
2/1/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
25
[/td][td]Rachael[/td][td]Johnson[/td][td]
2/1/2018​
[/td][td]
85​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
26
[/td][td]Kaylie[/td][td]Jones[/td][td]
2/1/2018​
[/td][td]
61​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
27
[/td][td]Kim[/td][td]Anderson[/td][td]
2/1/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
28
[/td][td]Mary[/td][td]Smith[/td][td]
2/1/2018​
[/td][td]
88​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
29
[/td][td]Val[/td][td]Hill[/td][td]
2/1/2018​
[/td][td]
69​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
30
[/td][td]Shawn[/td][td]Barnes[/td][td]
2/1/2018​
[/td][td]
99​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
31
[/td][td]Vicky[/td][td]Johnson[/td][td]
2/1/2018​
[/td][td]
68​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
32
[/td][td]Sally[/td][td]Jones[/td][td]
2/2/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
33
[/td][td]Jane[/td][td]Anderson[/td][td]
2/2/2018​
[/td][td]
85​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
34
[/td][td]Billy[/td][td]Smith[/td][td]
2/2/2018​
[/td][td]
80​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
35
[/td][td]Bobby[/td][td]Hill[/td][td]
2/2/2018​
[/td][td]
78​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
36
[/td][td]Alice[/td][td]Barnes[/td][td]
2/2/2018​
[/td][td]
85​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
37
[/td][td]Joe[/td][td]Johnson[/td][td]
2/2/2018​
[/td][td]
89​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
38
[/td][td]Gary[/td][td]Jones[/td][td]
2/2/2018​
[/td][td]
92​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
39
[/td][td]Carol[/td][td]Anderson[/td][td]
2/2/2018​
[/td][td]
63​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
40
[/td][td]Ann[/td][td]Smith[/td][td]
2/2/2018​
[/td][td]
71​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
41
[/td][td]Michael[/td][td]Hill[/td][td]
2/2/2018​
[/td][td]
63​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
42
[/td][td]Jessica[/td][td]Barnes[/td][td]
2/2/2018​
[/td][td]
72​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
43
[/td][td]Tim[/td][td]Johnson[/td][td]
2/2/2018​
[/td][td]
80​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
44
[/td][td]Peter[/td][td]Jones[/td][td]
2/2/2018​
[/td][td]
77​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
45
[/td][td]Cindy[/td][td]Anderson[/td][td]
2/2/2018​
[/td][td]
62​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
46
[/td][td]Ellen[/td][td]Smith[/td][td]
2/2/2018​
[/td][td]
60​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
47
[/td][td]Martha[/td][td]Hill[/td][td]
2/2/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
48
[/td][td]David[/td][td]Barnes[/td][td]
2/2/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
49
[/td][td]Matthew[/td][td]Johnson[/td][td]
2/2/2018​
[/td][td]
78​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
50
[/td][td]Joshua[/td][td]Jones[/td][td]
2/2/2018​
[/td][td]
70​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
51
[/td][td]Amy[/td][td]Anderson[/td][td]
2/2/2018​
[/td][td]
72​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
52
[/td][td]Tom[/td][td]Smith[/td][td]
2/2/2018​
[/td][td]
96​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
53
[/td][td]Ben[/td][td]Hill[/td][td]
2/2/2018​
[/td][td]
90​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
54
[/td][td]Alie[/td][td]Barnes[/td][td]
2/2/2018​
[/td][td]
87​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
55
[/td][td]Rachael[/td][td]Johnson[/td][td]
2/2/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
56
[/td][td]Kaylie[/td][td]Jones[/td][td]
2/2/2018​
[/td][td]
77​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
57
[/td][td]Kim[/td][td]Anderson[/td][td]
2/2/2018​
[/td][td]
61​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
58
[/td][td]Mary[/td][td]Smith[/td][td]
2/2/2018​
[/td][td]
99​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
59
[/td][td]Val[/td][td]Hill[/td][td]
2/2/2018​
[/td][td]
90​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
60
[/td][td]Shawn[/td][td]Barnes[/td][td]
2/2/2018​
[/td][td]
92​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
61
[/td][td]Vicky[/td][td]Johnson[/td][td]
2/2/2018​
[/td][td]
70​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
62
[/td][td]Sally[/td][td]Jones[/td][td]
2/3/2018​
[/td][td]
90​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
63
[/td][td]Jane[/td][td]Anderson[/td][td]
2/3/2018​
[/td][td]
85​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
64
[/td][td]Billy[/td][td]Smith[/td][td]
2/3/2018​
[/td][td]
77​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
65
[/td][td]Bobby[/td][td]Hill[/td][td]
2/3/2018​
[/td][td]
97​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
66
[/td][td]Alice[/td][td]Barnes[/td][td]
2/3/2018​
[/td][td]
94​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
67
[/td][td]Joe[/td][td]Johnson[/td][td]
2/3/2018​
[/td][td]
96​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
68
[/td][td]Gary[/td][td]Jones[/td][td]
2/3/2018​
[/td][td]
84​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
69
[/td][td]Carol[/td][td]Anderson[/td][td]
2/3/2018​
[/td][td]
88​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
70
[/td][td]Ann[/td][td]Smith[/td][td]
2/3/2018​
[/td][td]
95​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
71
[/td][td]Michael[/td][td]Hill[/td][td]
2/3/2018​
[/td][td]
80​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
72
[/td][td]Jessica[/td][td]Barnes[/td][td]
2/3/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
73
[/td][td]Tim[/td][td]Johnson[/td][td]
2/3/2018​
[/td][td]
87​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
74
[/td][td]Peter[/td][td]Jones[/td][td]
2/3/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
75
[/td][td]Cindy[/td][td]Anderson[/td][td]
2/3/2018​
[/td][td]
67​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
76
[/td][td]Ellen[/td][td]Smith[/td][td]
2/3/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
77
[/td][td]Martha[/td][td]Hill[/td][td]
2/3/2018​
[/td][td]
81​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
78
[/td][td]David[/td][td]Barnes[/td][td]
2/3/2018​
[/td][td]
69​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
79
[/td][td]Matthew[/td][td]Johnson[/td][td]
2/3/2018​
[/td][td]
81​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
80
[/td][td]Joshua[/td][td]Jones[/td][td]
2/3/2018​
[/td][td]
76​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
81
[/td][td]Amy[/td][td]Anderson[/td][td]
2/3/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
82
[/td][td]Tom[/td][td]Smith[/td][td]
2/3/2018​
[/td][td]
78​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
83
[/td][td]Ben[/td][td]Hill[/td][td]
2/3/2018​
[/td][td]
71​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
84
[/td][td]Alie[/td][td]Barnes[/td][td]
2/3/2018​
[/td][td]
62​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
85
[/td][td]Rachael[/td][td]Johnson[/td][td]
2/3/2018​
[/td][td]
100​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
86
[/td][td]Kaylie[/td][td]Jones[/td][td]
2/3/2018​
[/td][td]
92​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
87
[/td][td]Kim[/td][td]Anderson[/td][td]
2/3/2018​
[/td][td]
82​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
88
[/td][td]Mary[/td][td]Smith[/td][td]
2/3/2018​
[/td][td]
65​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
89
[/td][td]Val[/td][td]Hill[/td][td]
2/3/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
90
[/td][td]Shawn[/td][td]Barnes[/td][td]
2/3/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
91
[/td][td]Vicky[/td][td]Johnson[/td][td]
2/3/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
92
[/td][td]Sally[/td][td]Jones[/td][td]
2/4/2018​
[/td][td]
68​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
93
[/td][td]Jane[/td][td]Anderson[/td][td]
2/4/2018​
[/td][td]
72​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
94
[/td][td]Billy[/td][td]Smith[/td][td]
2/4/2018​
[/td][td]
97​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
95
[/td][td]Bobby[/td][td]Hill[/td][td]
2/4/2018​
[/td][td]
95​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
96
[/td][td]Alice[/td][td]Barnes[/td][td]
2/4/2018​
[/td][td]
78​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
97
[/td][td]Joe[/td][td]Johnson[/td][td]
2/4/2018​
[/td][td]
76​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
98
[/td][td]Gary[/td][td]Jones[/td][td]
2/4/2018​
[/td][td]
63​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
99
[/td][td]Carol[/td][td]Anderson[/td][td]
2/4/2018​
[/td][td]
60​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
100
[/td][td]Ann[/td][td]Smith[/td][td]
2/4/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
101
[/td][td]Michael[/td][td]Hill[/td][td]
2/4/2018​
[/td][td]
71​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
102
[/td][td]Jessica[/td][td]Barnes[/td][td]
2/4/2018​
[/td][td]
80​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
103
[/td][td]Tim[/td][td]Johnson[/td][td]
2/4/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
104
[/td][td]Peter[/td][td]Jones[/td][td]
2/4/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
105
[/td][td]Cindy[/td][td]Anderson[/td][td]
2/4/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
106
[/td][td]Ellen[/td][td]Smith[/td][td]
2/4/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
107
[/td][td]Martha[/td][td]Hill[/td][td]
2/4/2018​
[/td][td]
86​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
108
[/td][td]David[/td][td]Barnes[/td][td]
2/4/2018​
[/td][td]
83​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
109
[/td][td]Matthew[/td][td]Johnson[/td][td]
2/4/2018​
[/td][td]
91​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
110
[/td][td]Joshua[/td][td]Jones[/td][td]
2/4/2018​
[/td][td]
86​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
111
[/td][td]Amy[/td][td]Anderson[/td][td]
2/4/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
112
[/td][td]Tom[/td][td]Smith[/td][td]
2/4/2018​
[/td][td]
95​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
113
[/td][td]Ben[/td][td]Hill[/td][td]
2/4/2018​
[/td][td]
65​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
114
[/td][td]Alie[/td][td]Barnes[/td][td]
2/4/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
115
[/td][td]Rachael[/td][td]Johnson[/td][td]
2/4/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
116
[/td][td]Kaylie[/td][td]Jones[/td][td]
2/4/2018​
[/td][td]
60​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
117
[/td][td]Kim[/td][td]Anderson[/td][td]
2/4/2018​
[/td][td]
89​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
118
[/td][td]Mary[/td][td]Smith[/td][td]
2/4/2018​
[/td][td]
93​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
119
[/td][td]Val[/td][td]Hill[/td][td]
2/4/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
120
[/td][td]Shawn[/td][td]Barnes[/td][td]
2/4/2018​
[/td][td]
83​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
121
[/td][td]Vicky[/td][td]Johnson[/td][td]
2/4/2018​
[/td][td]
78​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
122
[/td][td]Sally[/td][td]Jones[/td][td]
2/5/2018​
[/td][td]
99​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
123
[/td][td]Jane[/td][td]Anderson[/td][td]
2/5/2018​
[/td][td]
75​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
124
[/td][td]Billy[/td][td]Smith[/td][td]
2/5/2018​
[/td][td]
64​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
125
[/td][td]Bobby[/td][td]Hill[/td][td]
2/5/2018​
[/td][td]
95​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
126
[/td][td]Alice[/td][td]Barnes[/td][td]
2/5/2018​
[/td][td]
79​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
127
[/td][td]Joe[/td][td]Johnson[/td][td]
2/5/2018​
[/td][td]
81​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
128
[/td][td]Gary[/td][td]Jones[/td][td]
2/5/2018​
[/td][td]
66​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
129
[/td][td]Carol[/td][td]Anderson[/td][td]
2/5/2018​
[/td][td]
62​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
130
[/td][td]Ann[/td][td]Smith[/td][td]
2/5/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
131
[/td][td]Michael[/td][td]Hill[/td][td]
2/5/2018​
[/td][td]
60​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
132
[/td][td]Jessica[/td][td]Barnes[/td][td]
2/5/2018​
[/td][td]
79​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
133
[/td][td]Tim[/td][td]Johnson[/td][td]
2/5/2018​
[/td][td]
65​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
134
[/td][td]Peter[/td][td]Jones[/td][td]
2/5/2018​
[/td][td]
73​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
135
[/td][td]Cindy[/td][td]Anderson[/td][td]
2/5/2018​
[/td][td]
63​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
136
[/td][td]Ellen[/td][td]Smith[/td][td]
2/5/2018​
[/td][td]
84​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
137
[/td][td]Martha[/td][td]Hill[/td][td]
2/5/2018​
[/td][td]
96​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
138
[/td][td]David[/td][td]Barnes[/td][td]
2/5/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
139
[/td][td]Matthew[/td][td]Johnson[/td][td]
2/5/2018​
[/td][td]
71​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
140
[/td][td]Joshua[/td][td]Jones[/td][td]
2/5/2018​
[/td][td]
65​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
141
[/td][td]Amy[/td][td]Anderson[/td][td]
2/5/2018​
[/td][td]
67​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
142
[/td][td]Tom[/td][td]Smith[/td][td]
2/5/2018​
[/td][td]
100​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
143
[/td][td]Ben[/td][td]Hill[/td][td]
2/5/2018​
[/td][td]
93​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
144
[/td][td]Alie[/td][td]Barnes[/td][td]
2/5/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
145
[/td][td]Rachael[/td][td]Johnson[/td][td]
2/5/2018​
[/td][td]
63​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
146
[/td][td]Kaylie[/td][td]Jones[/td][td]
2/5/2018​
[/td][td]
98​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
147
[/td][td]Kim[/td][td]Anderson[/td][td]
2/5/2018​
[/td][td]
99​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
148
[/td][td]Mary[/td][td]Smith[/td][td]
2/5/2018​
[/td][td]
97​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
149
[/td][td]Val[/td][td]Hill[/td][td]
2/5/2018​
[/td][td]
60​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
150
[/td][td]Shawn[/td][td]Barnes[/td][td]
2/5/2018​
[/td][td]
97​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
151
[/td][td]Vicky[/td][td]Johnson[/td][td]
2/5/2018​
[/td][td]
95​
[/td][/tr]
[/table]
[Table="width:, class:grid"][tr][td]Sheet: Sheet20[/td][/tr][/table]
 
Last edited:

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top