Spreadsheet: 40426d1238746335-top-10-from-two-criteria-678467_edmdas
Sheet: Data_PT

Name | House | Running Total | RANK |  | Data has header surplus headers removed & then been sorted by Cols B & C (Desc)
Student 58 | 0 | 38 |  |  | (Can be done with VBA obviously...)
Student 59 | 0 | 23 |  |  | Col D is a simple sequence formula.
Student 29 | 0 | 0
Student 30 | 0 | 0
Student 31 | 0 | 0
Student 60 | 0 | 0
Student 61 | 0 | 0
Student 62 | 0 | 0
Student 89 | 0 | 0
Student 90 | 0 | 0
Student 91 | 0 | 0
Student 92 | 0 | 0
Student 93 | 0 | 0
Student 120 | 0 | 0
Student 121 | 0 | 0
Student 122 | 0 | 0
Student 123 | 0 | 0
Student 124 | 0 | 0
Student 151 | 0 | 0
Student 152 | 0 | 0
Student 153 | 0 | 0
Student 154 | 0 | 0
Student 1 | Florence Nightingale | 231
Student 32 | Florence Nightingale | 231
Student 2 | Florence Nightingale | 225
Student 33 | Florence Nightingale | 225
Student 63 | Florence Nightingale | 189
Student 127 | Florence Nightingale | 184
Student 96 | Florence Nightingale | 177
Student 126 | Florence Nightingale | 175
Student 95 | Florence Nightingale | 140
Student 3 | Florence Nightingale | 108
Student 34 | Florence Nightingale | 108
Student 5 | Florence Nightingale | 99
Student 4 | Florence Nightingale | 88
Student 35 | Florence Nightingale | 88
Student 65 | Florence Nightingale | 85
Student 125 | Florence Nightingale | 76
Student 94 | Florence Nightingale | 72
Student 66 | Florence Nightingale | 70
Student 148 | Florence Nightingale | 64
Student 64 | Florence Nightingale | 61
Student 124 | Florence Nightingale | 61
Student 97 | Florence Nightingale | 30
Student 57 | Florence Nightingale | 28
Student 6 | Florence Nightingale | 4
Student 67 | Florence Nightingale | 0
Student 8 | [NAME] | 372
Student 39 | [NAME] | 372
Student 132 | [NAME] | 264
Student 129 | [NAME] | 240
Student 11 | [NAME] | 225
Student 10 | [NAME] | 196
Student 128 | [NAME] | 170
Student 133 | [NAME] | 153
Student 69 | [NAME] | 133
Student 9 | [NAME] | 120
Student 131 | [NAME] | 118
Student 7 | [NAME] | 112
Student 38 | [NAME] | 112
Student 36 | [NAME] | 99
Student 100 | [NAME] | 72
Student 70 | [NAME] | 69
Student 98 | [NAME] | 68
Student 102 | [NAME] | 53
Student 71 | [NAME] | 51
Student 68 | [NAME] | 48
Student 117 | [NAME] | 31
Student 99 | [NAME] | 27
Student 101 | [NAME] | 16
Student 37 | [NAME] | 4
Student 130 | [NAME] | 0
Student 134 | [NAME] | 355
Student 135 | [NAME] | 320
Student 136 | [NAME] | 230
Student 42 | [NAME] | 225
Student 41 | [NAME] | 196
Student 106 | [NAME] | 183
Student 14 | [NAME] | 174
Student 45 | [NAME] | 174
Student 73 | [NAME] | 145
Student 40 | [NAME] | 120
Student 15 | [NAME] | 117
Student 46 | [NAME] | 117
Student 75 | [NAME] | 100
Student 12 | [NAME] | 91
Student 43 | [NAME] | 91
Student 72 | [NAME] | 90
Student 17 | [NAME] | 86
Student 74 | [NAME] | 84
Student 76 | [NAME] | 82
Student 77 | [NAME] | 81
Student 103 | [NAME] | 76
Student 105 | [NAME] | 63
Student 16 | [NAME] | 47
Student 107 | [NAME] | 46
Student 13 | [NAME] | 36
Student 44 | [NAME] | 36
Student 104 | [NAME] | 31
Student 79 | [NAME] | 377
Student 139 | [NAME] | 372
Student 108 | [NAME] | 348
Student 21 | [NAME] | 306
Student 52 | [NAME] | 306
Student 82 | [NAME] | 303
Student 110 | [NAME] | 290
Student 137 | [NAME] | 265
Student 81 | [NAME] | 259
Student 19 | [NAME] | 188
Student 50 | [NAME] | 188
Student 109 | [NAME] | 156
Student 78 | [NAME] | 154
Student 142 | [NAME] | 134
Student 138 | [NAME] | 118
Student 80 | [NAME] | 110
Student 141 | [NAME] | 104
Student 48 | [NAME] | 86
Student 20 | [NAME] | 63
Student 51 | [NAME] | 63
Student 111 | [NAME] | 61
Student 88 | [NAME] | 50
Student 112 | [NAME] | 37
Student 26 | [NAME] | 28
Student 118 | [NAME] | 10
Student 18 | [NAME] | 0
Student 49 | [NAME] | 0
Student 140 | [NAME] | 0
Student 150 | [NAME] | 574
Student 143 | [NAME] | 440
Student 115 | [NAME] | 284
Student 144 | [NAME] | 158
Student 84 | [NAME] | 149
Student 23 | [NAME] | 137
Student 54 | [NAME] | 137
Student 86 | [NAME] | 130
Student 147 | [NAME] | 124
Student 116 | [NAME] | 115
Student 113 | [NAME] | 104
Student 85 | [NAME] | 99
Student 145 | [NAME] | 94
Student 146 | [NAME] | 94
Student 24 | [NAME] | 89
Student 55 | [NAME] | 89
Student 22 | [NAME] | 79
Student 53 | [NAME] | 79
Student 114 | [NAME] | 70
Student 87 | [NAME] | 63
Student 149 | [NAME] | 52
Student 47 | [NAME] | 47
Student 27 | [NAME] | 38
Student 83 | [NAME] | 31
Student 25 | [NAME] | 24
Student 56 | [NAME] | 24
Student 28 | [NAME] | 23
Student 119 | [NAME] | 1