Spreadsheet: 787749d1658003906-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-student-filter
Sheet: Sheet2

Range 1 |  |  |  |  |  |  |  |  |  | Range 3
Semester | First | Stage | Second |  |  |  |  |  |  | Name | Stage | Semester | Subject |  | Name | Stage | Semester | Subject
Name | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 |  |  |  |  | Student 1 | Second | First | sub.1
Student 1 | 45 | 67 | 66 | 51 | 47 |  |  |  |  | student 1 | Second | First | sub.5
Student 2 | 75 | 46 | 66 | 77 | 92 |  |  |  |  | student 2 | Second | First | sub,2
Student 3 | 35 | 55 | 60 | 51 | 43 |  |  |  |  | student 3 | Second | First | sub.1
Student 4 | 60 | 34 | 52 | 59 | 40 |  |  |  |  | student 3 | Second | First | sub,5
Student 5 | 55 | 60 | 55 | 59 | 69 |  |  |  |  | student 4 | Second | First | sub.2
Student 6 | 39 | 52 | 33 | 40 | 39 |  |  |  |  | student 4 | Second | First | sub.5
Student 7 | 71 | 65 | 68 | 77 | 59 |  |  |  |  | student 6 | Second | First | sub.1
Student 8 | 47 | 43 | 43 | 47 | 60 |  |  |  |  | student 6 | Second | First | [NAME]
Student 9 | 77.62952177700755 | 81.09478783997834 | 94.8405612539974 | 25.05547585122139 | 97.3944133130482
Student 10 | 85.83567224502822 | 75.66993803890563 | 18.83894633202892 | 31.0124398539269 | 44.60184072239203
Student 11 | 10.07303954425387 | 94.88722363973274 | 75.23235762344449 | 36.32653421101148 | 35.21190355843955
Student 12 | 12.35509573767238 | 46.11339096322211 | 66.39938010942541 | 70.33477243648927 | 25.08410938373007
Student 13 | 8.460964975003238 | 32.67608543565479 | 64.76829053369146 | 86.16631664762909 | 54.00875155165108
Student 14 | 3.398100142788774 | 2.44918266974008 | 73.7399218204111 | 21.24399464854775 | 60.4913033897205
Student 15 | 48.2783077254371 | 14.2721418451336 | 94.45580412304142 | 22.27390836673596 | 5.245192192560532
Student 16 | 97.71074513601938 | 9.219813123146114 | 85.84830116578784 | 75.4932200546828 | 30.53525914350097
Student 17 | 60.98099385230984 | 15.78729419343264 | 73.91950195986261 | 24.49367848875287 | 93.82468192057357
Student 18 | 13.42177519616928 | 30.67062954615215 | 84.85052586852527 | 55.97399055430606 | 68.20778616772495
Student 19 | 4.492249341943366 | 45.94719237865966 | 3.227511254374105 | 48.89662782208983 | 89.04506574353326
 |  |  |  |  |  |  |  |  |  | student  6 | Second | First | sub.4
 |  |  |  |  |  |  |  |  |  | student 6 | Second | First | sub.5
Range 2 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.1
 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.2
Semester | Second | Stage | Second |  |  |  |  |  |  | student 8 | Second | First | [NAME]
Name | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 |  |  |  |  | student 8 | Second | First | sub.4
Student 1 | 34 | 50 | 66 | 45 | 67 |  |  |  |  | student 1 | Second | second | sub.6
Student 2 | 51 | 92 | 66 | 55 | 46 |  |  |  |  | student 1 | Second | second | sub.9
Student 3 | 59 | 43 | 60 | 57 | 55 |  |  |  |  | student 2 | Second | second | sub.10
Student 4 | 34 | 40 | 52 | 40 | 34 |  |  |  |  | student3 | Second | second | sub.7
Student 5 | 46 | 69 | 55 | 35 | 60 |  |  |  |  | student 4 | Second | second | sub.6
Student 6 | 76 | 39 | 55 | 65 | 52 |  |  |  |  | student 4 | Second | second | sub.7
Student 7 | 61 | 59 | 68 | 55 | 65 |  |  |  |  | student 4 | Second | second | sub.9
Student 8 | 88 | 60 | 43 | 57 | 43 |  |  |  |  | student 4 | Second | second | sub.10
Student 9 | 40.56451797463068 | 77.33876530985903 | 51.51978805493572 | 18.38481982092075 | 62.53346122196406 |  |  |  |  | student 5 | Second | second | sub.6
Student 10 | 40.16896007777365 | 77.9924257669123 | 64.29817448547217 | 47.96973272960391 | 5.301409051256901 |  |  |  |  | student 5 | Second | second | sub,9
Student 11 | 97.64160614211356 | 85.91483082140104 | 0.0750903123738822 | 76.62199532551038 | 53.74659957550732 |  |  |  |  | student 6 | Second | second | sub.7
Student 12 | 95.90391466282085 | 78.4141338987257 | 30.95072991352745 | 27.26997983551931 | 33.21212287599099 |  |  |  |  | student 8 | Second | second | sub.8
Student 13 | 4.188223516238021 | 99.01223089456104 | 6.288811831618036 | 59.93646078052721 | 8.355875194371198 |  |  |  |  | student 8 | Second | second | sub.10
Student 14 | 37.13393758463855 | 62.31114094189577 | 30.91601455252316 | 69.12118927888088 | 92.06074946995322
Student 15 | 68.8660330941994 | 23.87254801586401 | 49.07442951891252 | 33.8110833657092 | 36.62837117324374
Student 16 | 54.88334580644845 | 29.33573833429507 | 50.03994588965915 | 89.18771257940212 | 82.40114534548171
Student 17 | 13.40247124944661 | 36.10611669272132 | 22.60431398437631 | 30.78306529084394 | 61.81783264150314
Student 18 | 63.37503434648023 | 20.88406955697463 | 5.751682010257541 | 27.70020919194895 | 28.77597878389101
Student 19 | 86.99570946110843 | 63.55502330381741 | 63.23014490225374 | 36.1966664444702 | 81.10679907275082