Spreadsheet: 807356d1669862865-sorting-formular-gd-three
Sheet: COLLECTOR

NO | CANDIDATE NAME | SEX M=1 &F=2 | WARD | SCHOOL | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | % OF PERFORMANCE | GRADE
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI &TEKNOLOJIA |  | M/JAMII & STADI ZA KAZI |  | URAIA NA MAADILI |  | S/KAZI |  |  |  |  |  |  |  |  |  | THIS IS THE OUTPUT I NEED AND I WRITE IT MANUAL
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
1 | BONIFAS MATHAYO TOIYEI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 |  | A |  |  |  | E. FIVE BEST STUDENTS
 | CHIRISTOPHER ABRAHAMU SANANGA | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 |  | A |  |  |  | NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 | DAUDI [NAME] | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 4 | E | 50 | A | 304 | 43.42857142857143 |  | A |  |  |  |  |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 | GREYSON AYUBU IDDY | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 37 | B | 32 | B | 4 | E | 27 | C | 250 | 35.71428571428572 |  | B |  |  |  |  |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | ELIA NEMUGOYO LEPERI | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 19 | D | 25 | C | 4 | E | 28 | C | 226 | 32.28571428571428 |  | B |  |  |  | 1 | BONIFAS MATHAYO TOIYEI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 | A
 | ELIA MESHACK  NGAIMEREKI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 23 | C | 25 | C | 4 | E | 22 | C | 224 | 32 |  | B |  |  |  |  | CHIRISTOPHER ABRAHAMU SANANGA | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 | A
 | EZEKIEL NAIGISA ROINE | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 15 | D | 20 | D | 4 | E | 27 | C | 216 | 30.85714285714286 |  | B |  |  |  |  | DAUDI [NAME] | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 4 | E | 50 | A | 304 | 43.42857142857143 | A
 | EZEKIEL NOAH OLOIBONI | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 21 | C | 11 | D | 4 | E | 10 | E | 196 | 28 |  | C |  |  |  |  | ENJO STANLEY MAJENDI | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 38 | B | 36 | B | 4 | E | 27 | C | 251 | 41.83333333333334 | A
 | [NAME] LENG'ATA | 1 | KINUA | NAMELOCK | 39 | B | 27 | C | 32 | B | 29 | C | 34 | B | 2 | E | 33 | B | 196 | 28 |  | C |  |  |  |  | GREYSON AYUBU IDDY | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 37 | B | 32 | B | 4 | E | 27 | C | 250 | 35.71428571428572 | B
 | FESTO ASSA MFUNDO | 1 | KINUA | NAMELOCK | 38 | B | 21 | C | 34 | B | 31 | B | 33 | B | 2 | E | 36 | B | 195 | 27.85714285714286 |  | C
 | FARAJA SIMON YOHANA | 1 | KINUA | NAMELOCK | 31 | B | 33 | B | 30 | C | 27 | C | 30 | C | 2 | E | 35 | B | 188 | 26.85714285714286 |  | C |  |  |  |  | THIS IS THE OUTPUT I NEED AND I WRITE IT MANUAL
 | IDDI ATHUMANI ALLY | 1 | KINUA | NAMELOCK | 33 | B | 15 | D | 25 | C | 25 | C | 29 | C | 2 | E | 31 | B | 160 | 22.85714285714286 |  | C |  |  |  | F. FIVE WEAK STUDENTS
 | ISACK TIMOTHEO MBEGA | 1 | KINUA | NAMELOCK | 36 | B | 24 | C | 21 | C | 20 | D | 29 | C | 2 | E | 28 | C | 160 | 22.85714285714286 |  | C |  |  |  | NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 | NURUDINI ATHUMANI HASSANI | 1 | KINUA | NAMELOCK | 34 | B | 15 | D | 24 | C | 26 | C | 26 | C | 2 | E | 26 | C | 153 | 21.85714285714286 |  | C |  |  |  |  |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 | ISAYA BENARD YOHANA | 1 | KINUA | NAMELOCK | 29 | C | 16 | D | 27 | C | 26 | C | 20 | D | 2 | E | 23 | C | 143 | 20.42857142857143 |  | D |  |  |  |  |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | LUTTA ROJA NIKOLAS | 1 | KINUA | NAMELOCK | 23 | C | 17 | D | 18 | D | 19 | D | 21 | C | 2 | E | 24 | C | 124 | 17.71428571428572 |  | D |  |  |  | 1 | NAISHIE GABRIEL TUKE | 2 | [NAME] | NAMELOCK | 26 | C | 19 | D | 15 | D | 12 | D | 23 | C | 3 | E | 19 | D | 114 | 19 | D
 | [NAME] | 1 | KINUA | NAMELOCK | 21 | C | 17 | D | 16 | D | 18 | D | 21 | C | 2 | E | 13 | D | 108 | 15.42857142857143 |  | D |  |  |  |  | [NAME] | 1 | KINUA | NAMELOCK | 21 | C | 17 | D | 16 | D | 18 | D | 21 | C | 2 | E | 13 | D | 108 | 15.42857142857143 | D
 | MAINGWA LARADAI LEKIRIAMA | 1 | KINUA | NAMELOCK | 21 | C | 11 | D | 19 | D | 19 | D | 16 | D | 2 | E | 18 | D | 106 | 15.14285714285714 |  | D |  |  |  |  | MAINGWA LARADAI LEKIRIAMA | 1 | KINUA | NAMELOCK | 21 | C | 11 | D | 19 | D | 19 | D | 16 | D | 2 | E | 18 | D | 106 | 15.14285714285714 | D
 | DANIEL MWEHE PAULO | 1 | KINUA | NAMELOCK | 21 | C | 13 | D | 14 | D | 16 | D | 21 | C | 2 | E | 12 | D | 99 | 14.14285714285714 |  | D |  |  |  |  | MUSUNGUI LAZARO ORMEMEI | 2 | [NAME] | NAMELOCK | 22 | C | 15 | D | 15 | D | 14 | D | 21 | C | 4 | E | 18 | D | 105 | 17.5 | D
 | ENJO STANLEY MAJENDI | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 38 | B | 36 | B | 4 | E | 27 | C | 251 | 41.83333333333334 |  | A |  |  |  |  | DANIEL MWEHE PAULO | 1 | KINUA | NAMELOCK | 21 | C | 13 | D | 14 | D | 16 | D | 21 | C | 2 | E | 12 | D | 99 | 14.14285714285714 | D
 | ENJO DICKSON LENGARWA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 29 | C | 28 | C | 2 | E | 38 | B | 245 | 40.83333333333334 |  | A
 | HALIMA MAULIDI RAMADHANI | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 29 | C | 30 | C | 6 | E | 28 | C | 237 | 39.5 |  | B |  |  |  |  | THIS IS THE OUTPUT I NEED AND I WRITE IT MANUAL
 | HAPPYNESS LOSERIAN ROINE | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 21 | C | 15 | D | 2 | E | 15 | D | 201 | 33.5 |  | B
 | HELENA  NDALU MAZOEYA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 13 | D | 15 | D | 4 | E | 18 | D | 196 | 32.66666666666666 |  | B |  |  |  | G. FIVE BEST MALE STUDENTS
 | GRACE LAMECK MOKIWA | 2 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 26 | C | 10 | E | 3 | E | 9 | E | 195 | 32.5 |  | B |  |  |  | NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 | [NAME] | 2 | [NAME] | NAMELOCK | 42 | A | 16 | D | 15 | D | 43 | A | 27 | C | 6 | E | 30 | C | 173 | 28.83333333333333 |  | C |  |  |  |  |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 | MARTA MUSA CHOYAI | 2 | [NAME] | NAMELOCK | 35 | B | 21 | C | 26 | C | 22 | C | 34 | B | 6 | E | 26 | C | 164 | 27.33333333333333 |  | C |  |  |  |  |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | [NAME] | 2 | [NAME] | NAMELOCK | 30 | C | 16 | D | 21 | C | 38 | B | 25 | C | 2 | E | 28 | C | 158 | 26.33333333333333 |  | C |  |  |  | 1 | BONIFAS MATHAYO TOIYEI | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 | A
 | LILIAN ZEPHANIA TWATI | 2 | [NAME] | NAMELOCK | 30 | C | 21 | C | 26 | C | 17 | D | 25 | C | 2 | E | 26 | C | 145 | 24.16666666666667 |  | C |  |  |  |  | CHIRISTOPHER ABRAHAMU SANANGA | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 350 | 50 | A
 | ROZI ISRAIL LEMJOMBA | 2 | [NAME] | NAMELOCK | 27 | C | 14 | D | 15 | D | 33 | B | 25 | C | 4 | E | 16 | D | 130 | 21.66666666666667 |  | C |  |  |  |  | DAUDI [NAME] | 1 | NAMELOCK | KALOLENI | 50 | A | 50 | A | 50 | A | 50 | A | 50 | A | 4 | E | 50 | A | 304 | 43.42857142857143 | A
 | REHEMA [NAME] | 2 | [NAME] | NAMELOCK | 27 | C | 15 | D | 15 | D | 22 | C | 23 | C | 2 | E | 19 | D | 121 | 20.16666666666667 |  | D |  |  |  |  | GREYSON AYUBU IDDY | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 37 | B | 32 | B | 4 | E | 27 | C | 250 | 35.71428571428572 | B
 | SARA GABRIEL [NAME] | 2 | [NAME] | NAMELOCK | 5 | E | 19 | D | 23 | C | 13 | D | 32 | B | 2 | E | 29 | C | 121 | 20.16666666666667 |  | D |  |  |  |  | ELIA NEMUGOYO LEPERI | 1 | NAMELOCK | NAMELOCK | 50 | A | 50 | A | 50 | A | 19 | D | 25 | C | 4 | E | 28 | C | 226 | 32.28571428571428 | B
 | NAISHIE GABRIEL TUKE | 2 | [NAME] | NAMELOCK | 26 | C | 19 | D | 15 | D | 12 | D | 23 | C | 3 | E | 19 | D | 114 | 19 |  | D
 | MUSUNGUI LAZARO ORMEMEI | 2 | [NAME] | NAMELOCK | 22 | C | 15 | D | 15 | D | 14 | D | 21 | C | 4 | E | 18 | D | 105 | 17.5 |  | D |  |  |  | H. FIVE WEAK MALE STUDENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | ISAYA BENARD YOHANA | 1 | KINUA | NAMELOCK | 29 | C | 16 | D | 27 | C | 26 | C | 20 | D | 2 | E | 23 | C | 143 | 20.42857142857143 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LUTTA ROJA NIKOLAS | 1 | KINUA | NAMELOCK | 23 | C | 17 | D | 18 | D | 19 | D | 21 | C | 2 | E | 24 | C | 124 | 17.71428571428572 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 | KINUA | NAMELOCK | 21 | C | 17 | D | 16 | D | 18 | D | 21 | C | 2 | E | 13 | D | 108 | 15.42857142857143 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAINGWA LARADAI LEKIRIAMA | 1 | KINUA | NAMELOCK | 21 | C | 11 | D | 19 | D | 19 | D | 16 | D | 2 | E | 18 | D | 106 | 15.14285714285714 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DANIEL MWEHE PAULO | 1 | KINUA | NAMELOCK | 21 | C | 13 | D | 14 | D | 16 | D | 21 | C | 2 | E | 12 | D | 99 | 14.14285714285714 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS IS THE OUTPUT I NEED AND I WRITE IT MANUAL
 | UFUNGUO
 | 1 | WAVULANA
 | 2 | [NAME]
 | A | ALAMA
 | D | DARAJA
 | SHULE | DARAJA |  | SOMO | KISW |  | ENGL |  | [NAME] |  | SAYA&T |  | M/JAMII |  | U&MAAD |  | S/KAZI
 |  |  |  | JINSI | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  |  | JML