Spreadsheet: 788589d1658563868-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-formal-table-2-
Sheet: P2

No. | Student Name |  | Second |  |  |  |  |  |  |  |  |  | Stage |  |  |  |  |  |  |  |  |  |  | P3 |  |  | P2 |  |  | P1
 |  |  | First |  |  |  |  |  |  | Semester: |  |  |  |  |  |  |  | Second |  |  |  |  |  |  | Semester:
 |  |  | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 | Sub.11 | Sub.12 | Sub.13 | Sub.14 |  | sub.1 | sub.2 | [NAME] | sub.4 | sub.5 | sub.6 | sub.7 | sub.8 | sub.9 | sub.10 | sub.11 | sub.12 | sub.13 | sub.14
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | Student name 1 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  | 55 |  | 65 | 87 | 39 | 45 | 66 | 49
 | student name 2 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  | 45 |  | 35 |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 3 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  | 67 |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 4 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 5 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  | 77 |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 6 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 7 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 8 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 9 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 10 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 11 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 12 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 13 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  | 45 |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 14 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 15 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 16 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 17 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 18 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 19 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 20 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 77 | 67 | 48 | 51
 | Student name 21 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 | 40 | 61 | 80 | 77 |  |  |  |  |  |  | 43
 | Student name 22 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 80 | 42 | 77 | 67 | 45 | 91
 | Student name 23 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 45 |  | 50 | 37 | 77 | 25
 | Student name 24 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 77 | 80 | 39 | 30 | 47 | 50 |  |  |  |  | 55
 | Student name 25 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 26 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  | 57 |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 27 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 28 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 29 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  | 40
 | Student name 30 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 31 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 32 |  | 45 | 40 | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 33 |  | 77 |  | 44 | 40 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 34 |  | 47 | 50 | 67 |  | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 35 |  | 65 | 66 | 39 | 50 | 66 | 49 |  |  |  |  |  |  |  | 60 |  | 48 | 52 |  | 61 | 40 | 77 |  |  | 50
 | Student name 36 |  | 50 | 44 | 40 | 66 | 77 | 51 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 37 |  | 48 | 67 |  | 44 | 40 | 77 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 38 |  | 80 | 39 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 39 |  | 45 |  | 66 | 39 | 50 | 25 |  |  |  |  | 45 |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 40 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 41 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 42 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 43 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44 |  |  |  | 45
 | Student name 44 |  | 48 | 52 | 40 | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 45 |  | 80 | 42 |  | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 50 | 35 | 77 | 67 | 48 | 51
 | Student name 46 |  | 45 |  | 50 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 | 40 | 61 | 80 | 77
 | Student name 47 |  | 77 | 80 | 66 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 80 | 42 | 77 | 67 | 45 | 91
 | Student name 48 |  | 47 | 54 | 44 | 50 | 58 | 44 |  |  |  |  |  |  |  | 42 |  | 45 |  | 50 | 37 | 77 | 25
 | Student name 49 |  | 65 | 87 | 67 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 77 | 80 | 39 | 30 | 47 | 50
 | Student name 50 |  | 50 | 35 | 39 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 51 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 52 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 53 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 54 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  | 49
 | Student name 55 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 56 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 57 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 58 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 59 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 60 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  | 45 |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 61 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 62 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 63 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 64 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 65 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 66 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 67 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 68 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 69 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 70 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 71 |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44 |  |  |  | 55
 | Student name 72 |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 73 |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  |  | 50 | 35 | 77 | 67 | 48 | 51
 | Student name 74 |  | 45 | 40 | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 | 40 | 61 | 80 | 77
 | Student name 75 |  | 77 |  | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 80 | 42 | 77 | 67 | 45 | 91
 | Student name 76 |  | 47 | 50 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 45 |  | 50 | 37 | 77 | 25
 | Student name 77 |  | 65 | 66 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 77 | 80 | 39 | 30 | 47 | 50
 | Student name 78 |  | 50 | 44 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 79 |  | 48 | 67 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 80 |  | 80 | 39 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  | 55 |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 81 |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 82 |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 83 |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 84 |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 85 |  | 50 | 35 | 77 | 67 | 48 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 86 |  | 48 | 52 | 40 | 61 | 80 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 87 |  | 80 | 42 | 77 | 67 | 45 | 91 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 88 |  | 45 |  | 50 | 37 | 77 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77
 | Student name 89 |  | 77 | 80 | 39 | 30 | 47 | 50 |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91
 | Student name 90 |  | 47 | 54 | 58 | 50 | 65 | 44 |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25
 | Student name 91 |  | 65 | 87 | 66 | 45 | 50 | 49 |  |  |  |  | 35 |  |  |  |  | 77 | 80 | 44 | 30 | 39 | 50
 | Student name 92 |  | 50 | 35 | 77 | 67 | 48 | 51 |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44
 | Student name 93 |  | 48 | 52 | 40 | 61 | 80 | 77 |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49
 | Student name 94 |  | 80 | 42 | 77 | 67 | 45 | 91 |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51
 | Student name 95 |  | 45 |  | 50 | 37 | 77 | 25 |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  | 35
 | Student name 96 |  | 77 | 80 | 39 | 30 | 47 | 50 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 97 |  | 47 | 54 | 58 | 50 | 65 | 44 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 98 |  | 65 | 87 | 66 | 45 | 50 | 49 |  |  |  |  |  |  |  |  |  | 50 | 35 | 77 | 67 | 48 | 51
 | Student name 99 |  | 50 | 35 | 77 | 67 | 48 | 51 |  |  |  |  |  |  |  | 34 |  | 48 | 52 | 40 | 61 | 80 | 77
 | Student name 100 |  | 48 | 52 | 40 | 61 | 80 | 77 |  |  |  |  |  |  |  |  |  | 80 | 42 | 77 | 67 | 45 | 91
 | Student name 101 |  | 80 | 42 | 77 | 67 | 45 | 91 |  |  |  |  |  |  |  |  |  | 45 |  | 50 | 37 | 77 | 25
 | Student name 102 |  | 45 |  | 50 | 37 | 77 | 25 |  |  |  |  |  |  |  |  |  | 77 | 80 | 39 | 30 | 47 | 50
 | Student name 103 |  | 77 | 80 | 39 | 30 | 47 | 50 |  |  |  |  |  |  |  |  |  | 47 | 54 | 58 | 50 | 65 | 44
 | Student name 104 |  | 47 | 54 | 58 | 50 | 65 | 44 |  |  |  |  |  |  |  |  |  | 65 | 87 | 66 | 45 | 50 | 49
 | Student name 105 |  | 65 | 87 | 66 | 45 | 50 | 49 |  |  |  |  |  |  |  |  |  | 44 |  |  | 50 | 55 | 35 |  |  |  |  |  |  | 66