Spreadsheet: 538118d1505411603-function-or-pivot-table-forum-example
Sheet: Sheet1

Lesson Number | Students | Expected Duration | Instructor | Actual Hours | Diff | Is > 0.2
1 | Student 1 | 1.4 | [NAME] | 1.4
2 | Student 1 | 1.4 | [NAME] | 1.4 |  |  |  |  | Row Labels | Sum of Is > 0.2
3 | Student 1 | 1.4 | [NAME] | 1.5 |  |  |  |  |  | 0
4 | Student 1 | 1.4 | [NAME] | 1.5 |  |  |  |  | Adam | 0
5 | Student 1 | 1.2 | [NAME] | 0.5 |  |  |  |  | Amanda | 0
6 | Student 1 | 1.4 | [NAME] | 1.4 |  |  |  |  | [NAME] | 3
7 | Student 1 | 1.2 | [NAME] | 1.1 |  |  |  |  | [NAME] | 0
8 | Student 1 | 1.2 | [NAME] | 1.1 |  |  |  |  | [NAME] | 3
9 | Student 1 | 1.2 | [NAME] | 1.3 |  |  |  |  | [NAME] | 0
10 | Student 1 | 1.2 | [NAME] | 1.3 |  |  |  |  | [NAME] | 1
11 | Student 1 | 1.2 | [NAME] | 1.5 |  |  |  |  | [NAME] | 0
12 | Student 1 | 1.2 | [NAME] | 1.5 |  |  |  |  | Nick | 0
13 | Student 1 | 1.2 | [NAME] | 1.4 |  |  |  |  | [NAME] | 0
14 | Student 1 | 0.8 | [NAME] | 0.9 |  |  |  |  | SELF | 0
15 | Student 1 | 1.2 | SELF | 1.3 |  |  |  |  | [NAME] | 0
16 | Student 1 | 1.2 | [NAME] | 1.2 |  |  |  |  | [NAME] | 3
17 | Student 1 | 1 | [NAME] | 0.9 |  |  |  |  | [NAME] | 0
18 | Student 1 | 1.2 | [NAME] | 1.2 |  |  |  |  | (blank)
19 | Student 1 | 1.3 | [NAME] | 1.3 |  |  |  |  | Grand Total | 10
20 | Student 1 | 1.4 | [NAME] | 1.5
21 | Student 1 | 1.4 | [NAME] | 1.3
22 | Student 1 | 1.6 | [NAME] | 1.3
23 | Student 1 | 1.5 | [NAME] | 1.4
24 | Student 1 | 1.4 | [NAME] | 1.5
25 | Student 1 | 1.5 | [NAME] | 2.2
26 | Student 1 | 1 | [NAME] | 1
27 | Student 1 | 1 | [NAME] | 0
28 | Student 1 | 1 | [NAME] | 1.1
29 | Student 1 | 1 | [NAME] | 0
30 | Student 1 | 1.4 | [NAME] | 1.4
31 | Student 1 | 1.4 | [NAME] | 0.5
32 | Student 1 | 1.5 | [NAME] | 1.7
33 | Student 1 | 1.6 | [NAME] | 1.7
34 | Student 1 | 1.6 | [NAME] | 1.7
35 | Student 1 | 1.5
36 | Student 1 | 1 | [NAME] | 0
37 | Student 1 | 1 | [NAME] | 0
38 | Student 1 | 1 | [NAME] | 0
39 | Student 1 | 1 | [NAME] | 0
40 | Student 1 | 1.5 | [NAME] | 1.5
41 | Student 1 | 1.9 | [NAME] | 1.8
42 | Student 1 | 2.6 | [NAME] | 2.8
43 | Student 1 | 2.3 | [NAME] | 2.2
44 | Student 1 | 2.8 | [NAME] | 1.4
45 | Student 1 | 2
46 | Student 1 | 2 | Nick | 0.9
47 | Student 1 | 1.4 | [NAME] | 1.4
48 | Student 1 | 1.2 | [NAME] | 1.2
1 | Student 2 | 1.4 | [NAME] | 1.1
2 | Student 2 | 1.4 | [NAME] | 1.4
3 | Student 2 | 1.4 | [NAME] | 1.4
4 | Student 2 | 1.4 | Adam | 1.4
5 | Student 2 | 1.2 | [NAME] | 1.3
6 | Student 2 | 1.4 | [NAME] | 1.4
7 | Student 2 | 1.2 | [NAME] | 1.2
8 | Student 2 | 1.2 | [NAME] | 1.2
9 | Student 2 | 1.2 | [NAME] | 1.2
10 | Student 2 | 1.2 | [NAME] | 1.1
11 | Student 2 | 1.2 | [NAME] | 1
12 | Student 2 | 1.2 | [NAME] | 1.2
13 | Student 2 | 1.2 | [NAME] | 0.9
14 | Student 2 | 0.8 | [NAME] | 0.9
15 | Student 2 | 1.2 | [NAME] | 1.1
16 | Student 2 | 1.2 | [NAME] | 1.4
17 | Student 2 | 1 | [NAME] | 1.4
18 | Student 2 | 1.2 | Adam | 1
19 | Student 2 | 1.3 | Adam | 1.4
20 | Student 2 | 1.4 | [NAME] | 1.3
21 | Student 2 | 1.4 | [NAME] | 1.4
22 | Student 2 | 1.6 | [NAME] | 1.5
23 | Student 2 | 1.5 | [NAME] | 1.5
24 | Student 2 | 1.4 | [NAME] | 1.4
25 | Student 2 | 1.5 | [NAME] | 2
26 | Student 2 | 1 | [NAME] | 1
27 | Student 2 | 1 | [NAME] | 0
28 | Student 2 | 1 | [NAME] | 1.2
29 | Student 2 | 1
30 | Student 2 | 1.4 | [NAME] | 1.7
31 | Student 2 | 1.4 | [NAME] | 1.3
32 | Student 2 | 1.5 | [NAME] | 1.5
33 | Student 2 | 1.6 | [NAME] | 1.7
34 | Student 2 | 1.6 | [NAME] | 1.3
35 | Student 2 | 1.5
36 | Student 2 | 1 | [NAME] | 0
37 | Student 2 | 1 | [NAME] | 0
38 | Student 2 | 1 | [NAME] | 0
39 | Student 2 | 1 | [NAME] | 0
40 | Student 2 | 1.5 | [NAME] | 1.6
41 | Student 2 | 1.9 | Amanda | 1.9
42 | Student 2 | 2.6 | [NAME] | 2.8
43 | Student 2 | 2.3
44 | Student 2 | 2.8
45 | Student 2 | 2 | [NAME] | 2.1
46 | Student 2 | 2 | Nick | 2.2
47 | Student 2 | 1.4 | [NAME] | 1.4
48 | Student 2 | 1.2 | [NAME] | 1.2
1 | Student 3 | 1.4 | [NAME] | 1.5
2 | Student 3 | 1.4 | [NAME] | 1.4
3 | Student 3 | 1.4 | [NAME] | 1.4
4 | Student 3 | 1.4 | [NAME] | 1.4
5 | Student 3 | 1.2 | Adam | 1.4
6 | Student 3 | 1.4 | [NAME] | 1.2
7 | Student 3 | 1.2 | [NAME] | 1.1
8 | Student 3 | 1.2 | [NAME] | 0.7
9 | Student 3 | 1.2 | [NAME] | 0.7
10 | Student 3 | 1.2 | Adam | 1.3
11 | Student 3 | 1.2 | [NAME] | 1.1
12 | Student 3 | 1.2 | [NAME] | 0.5
13 | Student 3 | 1.2 | [NAME] | 1.5
14 | Student 3 | 0.8 | [NAME] | 0.9
15 | Student 3 | 1.2 | [NAME] | 1.2
16 | Student 3 | 1.2 | [NAME] | 1.1
17 | Student 3 | 1 | [NAME] | 1.1
18 | Student 3 | 1.2 | [NAME] | 1.3
19 | Student 3 | 1.3 | [NAME] | 1.2
20 | Student 3 | 1.4 | [NAME] | 1.3
21 | Student 3 | 1.4 | [NAME] | 1.3
22 | Student 3 | 1.6 | Adam | 1.5
23 | Student 3 | 1.5 | [NAME] | 1.5
24 | Student 3 | 1.4 | [NAME] | 1.2
25 | Student 3 | 1.5 | [NAME] | 2.3
26 | Student 3 | 1 | [NAME] | 1.1
27 | Student 3 | 1 | [NAME] | 0
28 | Student 3 | 1 | [NAME] | 1.1
29 | Student 3 | 1
30 | Student 3 | 1.4 | [NAME] | 1.2
31 | Student 3 | 1.4 | [NAME] | 1.6
32 | Student 3 | 1.5 | [NAME] | 1.6
33 | Student 3 | 1.6 | [NAME] | 1.6
34 | Student 3 | 1.6 | [NAME] | 1.9
35 | Student 3 | 1.5
36 | Student 3 | 1 | [NAME] | 0
37 | Student 3 | 1 | [NAME] | 0
38 | Student 3 | 1 | [NAME] | 0
39 | Student 3 | 1 | [NAME] | 0
40 | Student 3 | 1.5 | [NAME] | 1.4
41 | Student 3 | 1.9 | [NAME] | 1.7
42 | Student 3 | 2.6 | [NAME] | 2.9
43 | Student 3 | 2.3 | [NAME] | 2.1
44 | Student 3 | 2.8 | [NAME] | 1.5
45 | Student 3 | 2 | [NAME] | 1.6
46 | Student 3 | 2
47 | Student 3 | 1.4
48 | Student 3 | 1.2