Spreadsheet: 152590d1335446933-grouping-data-based-on-multiple-criteria-data-for-stats
Sheet: Data

 | [NAME] for 100 students - all marks given as percentages
 | Attendance | subject 1 | subject 2 | subject 3 | subject 4 | subject 5 | subject 6 | subject 7
 | 78 | 78 | 50 | 65 | 61 | 32 | 57 | 44
 | 29 | 51 | 41 | 20 | 14 | 6 | 3 | 2
 | 41 | 55 | 27 | 22 | 15 | 0 | 12 | 9
 | 73 | 75 | 26 | 58 | 57 | 6 | 32 | 25
 | 49 | 66 | 75 | 53 | 46 | 60 | 37 | 25
 | 95 | 77 | 76 | 71 | 63 | 49 | 49 | 35
 | 67 | 73 | 68 | 72 | 63 | 56 | 52 | 37
 | 86 | 86 | 82 | 76 | 77 | 58 | 67 | 60
 | 83 | 73 | 87 | 80 | 77 | 73 | 61 | 53
 | 78 | 82 | 82 | 74 | 67 | 53 | 58 | 58
 | 56 | 75 | 34 | 61 | 52 | 30 | 35 | 45
 | 37 | 63 | 38 | 50 | 45 | 41 | 52 | 42
 | 57 | 78 | 55 | 46 | 40 | 37 | 40 | 34
 | 25 | 64 | 71 | 12 | 8 | 12 | 3 | 4
 | 98 | 89 | 96 | 87 | 86 | 78 | 73 | 52
 | 32 | 45 | 57 | 41 | 40 | 42 | 40 | 30
 | 97 | 86 | 72 | 78 | 72 | 58 | 71 | 61
 | 88 | 72 | 47 | 63 | 54 | 34 | 34 | 41
 | 98 | 87 | 83 | 73 | 70 | 45 | 54 | 57
 | 62 | 81 | 80 | 74 | 67 | 70 | 49 | 58
 | 26 | 56 | 52 | 58 | 50 | 35 | 44 | 41
 | 42 | 52 | 40 | 51 | 44 | 30 | 40 | 35
 | 93 | 74 | 46 | 73 | 70 | 68 | 53 | 49
 | 66 | 82 | 76 | 70 | 69 | 62 | 64 | 52
 | 99 | 79 | 90 | 80 | 71 | 51 | 72 | 62
 | 73 | 73 | 72 | 51 | 41 | 31 | 49 | 34
 | 79 | 88 | 81 | 80 | 78 | 52 | 59 | 59
 | 62 | 77 | 78 | 74 | 64 | 52 | 55 | 57
 | 66 | 79 | 64 | 55 | 55 | 34 | 59 | 45
 | 92 | 79 | 92 | 77 | 68 | 68 | 61 | 51
 | 60 | 82 | 94 | 65 | 55 | 50 | 51 | 51
 | 84 | 88 | 93 | 83 | 75 | 72 | 61 | 52
 | 74 | 46 | 34 | 36 | 34 | 12 | 18 | 10
 | 94 | 87 | 74 | 73 | 71 | 60 | 59 | 55
 | 30 | 81 | 71 | 72 | 68 | 49 | 57 | 45
 | 74 | 75 | 59 | 43 | 44 | 43 | 41 | 35
 | 98 | 84 | 72 | 87 | 87 | 67 | 76 | 67
 | 51 | 67 | 59 | 44 | 31 | 30 | 38 | 33
 | 56 | 67 | 45 | 33 | 28 | 24 | 30 | 30
 | 83 | 80 | 74 | 71 | 62 | 50 | 54 | 54
 | 82 | 74 | 71 | 73 | 77 | 53 | 62 | 60
 | 94 | 80 | 67 | 81 | 78 | 53 | 62 | 62
 | 42 | 77 | 64 | 63 | 47 | 36 | 61 | 56
 | 79 | 80 | 64 | 62 | 48 | 46 | 42 | 47
 | 44 | 79 | 71 | 69 | 59 | 51 | 54 | 50
 | 81 | 67 | 52 | 63 | 55 | 36 | 52 | 43
 | 64 | 65 | 98 | 74 | 70 | 65 | 57 | 53
 | 99 | 86 | 92 | 86 | 92 | 76 | 73 | 71
 | 85 | 76 | 53 | 55 | 50 | 32 | 48 | 46
 | 26 | 77 | 62 | 54 | 58 | 41 | 56 | 33
 | 54 | 40 | 40 | 40 | 40 | 37 | 42 | 40
 | 69 |  | 34 | 9 | 5 | 23 | 40 | 29
 | 47 | 79 | 51 | 54 | 57 | 30 | 56 | 33
 | 87 | 85 | 78 | 77 | 76 | 46 | 64 | 48
 | 54 | 85 | 58 | 74 | 71 | 72 | 59 | 54
 | 86 | 89 | 83 | 88 | 82 | 69 | 74 | 58
 | 81 | 74 | 71 | 67 | 60 | 34 | 57 | 40
 | 94 | 79 | 92 | 78 | 74 | 69 | 65 | 57
 | 17 | 74 | 50 | 23 | 20 | 31 | 6 | 17
 | 45 | 73 | 59 | 48 | 42 | 36 | 34 | 43
 | 91 | 87 | 98 | 88 | 87 | 86 | 64 | 68
 | 51 | 76 | 44 | 62 | 58 | 31 | 36 | 44
 | 44 | 62 | 79 | 35 | 41 | 27 | 27 | 24
 | 45 | 56 | 47 | 44 | 48 | 25 | 34 | 33
 | 55 | 4 | 0 | 23 | 14 | 14 | 20 | 25
 | 87 | 93 | 97 | 88 | 92 | 80 | 78 | 75
 | 39 | 63 | 60 | 22 | 19 | 8 | 6 | 4
 | 82 | 83 | 70 | 71 | 68 | 67 | 60 | 54
 | 92 | 84 | 79 | 74 | 71 | 46 | 52 | 43
 | 36 | 66 | 44 | 62 | 43 | 40 | 24 | 32
 | 79 | 87 | 90 | 77 | 76 | 70 | 56 | 51
 | 63 | 82 | 65 | 53 | 47 | 35 | 44 | 41
 | 94 | 66 | 55 | 52 | 52 | 37 | 42 | 42
 | 63 | 71 | 82 | 75 | 66 | 59 | 55 | 52
 | 89 | 76 | 67 | 57 | 64 | 44 | 43 | 41
 | 71 | 78 | 68 | 72 | 67 | 40 | 58 | 50
 | 45 | 54 | 52 | 20 | 23 | 24 | 33 | 16
 | 49 | 86 | 74 | 75 | 78 | 52 | 62 | 64
 | 84 | 81 | 67 | 81 | 75 | 52 | 64 | 54
 | 78 | 66 | 53 | 36 | 38 | 24 | 20 | 19
 | 52 | 60 | 86 | 43 | 43 | 39 | 40 | 32
 | 56 | 71 | 76 | 53 | 40 | 40 | 40 | 4
 | 70 | 72 | 90 | 73 | 72 | 75 | 53 | 64
 | 92 | 84 | 73 | 74 | 70 | 67 | 64 | 49
 | 91 | 87 | 73 | 81 | 79 | 63 | 64 | 59
 | 95 | 75 | 50 | 52 | 43 | 29 | 36 | 33
 | 89 | 89 | 85 | 87 | 88 | 61 | 79 | 76
 | 59 | 59 | 41 | 40 | 40 | 38 | 48 | 41
 | 55 | 93 | 95 | 79 | 83 | 81 | 65 | 66
 | 98 | 75 | 95 | 80 | 81 | 81 | 62 | 64
 | 69 | 77 | 78 | 72 | 67 | 66 | 54 | 53
 | 85 | 81 | 98 | 88 | 88 | 85 | 66 | 66
 | 64 | 67 | 48 | 40 | 34 | 41 | 27 | 18
 | 65 | 80 | 62 | 64 | 56 | 28 | 61 | 49
 | 60 | 59 | 45 | 40 | 34 | 9 | 32 | 20
 | 56 | 81 | 67 | 42 | 55 | 5 | 31 | 37
 | 49 | 66 | 71 | 29 | 27 | 23 | 23 | 11
 | 59 | 63 | 40 | 33 | 27 | 20 | 14 | 3
 | 87 | 87 | 84 | 73 | 75 | 69 | 47 | 48
 | 40 | 27 | 7 | 51 | 33 | 30 | 24 | 28