Can anyone understand this?

[BlackMane]

Under CT1, use an appropriate function to find the highest class test mark for each student, using the class test percentages on the PROGRESS MARK worksheet. there are three sheets here first one being PROGRESS MARKS/ATTENDANCE RECORDS and last one MARK CALCULATIONS.

BEBE	SUYEBULELE TUNCEN
BEKU	THUMEKE
BERTLETT	MURNEY
BRUTZ	MERUETTE JECULUNE
BUNTWUNU	TENUEL
CHUKTE	ZEHEER EHMET
CHULEYU	BUMKEZU
ETEMS	JEEN-LEE CHRUSTUPHER
GCEYUYE	SENTLE
GEGENE	BUSUSUWE ****Y
HENTRUCKS	NUCULE TERYN
JEKEVULE	LELETHU BRUNWYNE
KUKESE	NGUENGU
LUCHEBE	METEBUU VERUNUCE
LUGEYENU	ETHU ENKUSU
LUURENCU	TERCUU CHUCELUE
MBEMBENU	NUSUBULELU
MEFULEKU	FRUETHELM NELETU
MEGENGELELE	EPHUWE
MEKEBE	EKHUNE
MELENGU	GEBY KESUNGU
MENGQUBE	ENETHU YULENTE

[TD="class: xl63"]Stud num[/TD]
[TD="width: 100"]Last Name[/TD]
[TD="width: 229"]First Name[/TD]
[TD="class: xl64, width: 76"]CT1[/TD]
[TD="class: xl64, width: 64"]CT2[/TD]
[TD="class: xl64, width: 64"]CT3[/TD]
[TD="class: xl64, width: 64"]CT4[/TD]
[TD="class: xl64, width: 64"]CT5[/TD]

[TD="class: xl63, colspan: 3"]Total[/TD]
[TD="class: xl66, width: 76"]100[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[TD="class: xl66, width: 64"]100[/TD]
[TD="class: xl66, width: 64"]100[/TD]

[TD="class: xl63"]208055193[/TD]

[TD="class: xl68"]40[/TD]
[TD="class: xl68"]87[/TD]
[TD="class: xl68"]80[/TD]
[TD="class: xl68"]83[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]208105085[/TD]

[TD="class: xl68"]80[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]71[/TD]
[TD="class: xl68"]80[/TD]
[TD="class: xl68"]71[/TD]

[TD="class: xl63"]208121854[/TD]

[TD="class: xl68"]29[/TD]
[TD="class: xl68"]93[/TD]
[TD="class: xl68"]91[/TD]
[TD="class: xl68"]89[/TD]
[TD="class: xl68"]74[/TD]

[TD="class: xl63"]210237791[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]210189770[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]46[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]210182970[/TD]

[TD="class: xl68"]87[/TD]
[TD="class: xl68"]83[/TD]
[TD="class: xl68"]83[/TD]
[TD="class: xl68"]91[/TD]
[TD="class: xl68"]86[/TD]

[TD="class: xl63"]208074287[/TD]

[TD="class: xl68"]67[/TD]
[TD="class: xl68"]53[/TD]
[TD="class: xl68"]57[/TD]
[TD="class: xl68"]51[/TD]
[TD="class: xl68"]69[/TD]

[TD="class: xl63"]210225904[/TD]

[TD="class: xl68"]77[/TD]
[TD="class: xl68"]70[/TD]
[TD="class: xl68"]69[/TD]
[TD="class: xl68"]74[/TD]
[TD="class: xl68"]83[/TD]

[TD="class: xl63"]208006605[/TD]

[TD="class: xl68"]33[/TD]
[TD="class: xl68"]73[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]77[/TD]
[TD="class: xl68"]83[/TD]

[TD="class: xl63"]208037357[/TD]

[TD="class: xl68"]57[/TD]
[TD="class: xl68"]73[/TD]
[TD="class: xl68"]74[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]54[/TD]

[TD="class: xl63"]208070079[/TD]

[TD="class: xl68"]93[/TD]
[TD="class: xl68"]73[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]89[/TD]

[TD="class: xl63"]210134143[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]34[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]209169931[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]83[/TD]
[TD="class: xl68"]89[/TD]
[TD="class: xl68"]69[/TD]
[TD="class: xl68"]54[/TD]

[TD="class: xl63"]210179694[/TD]

[TD="class: xl68"]80[/TD]
[TD="class: xl68"]73[/TD]
[TD="class: xl68"]77[/TD]
[TD="class: xl68"]66[/TD]
[TD="class: xl68"]86[/TD]

[TD="class: xl63"]208143742[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]57[/TD]
[TD="class: xl68"]51[/TD]
[TD="class: xl68"]0[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]207094012[/TD]

[TD="class: xl68"]87[/TD]
[TD="class: xl68"]77[/TD]
[TD="class: xl68"]66[/TD]
[TD="class: xl68"]94[/TD]
[TD="class: xl68"]83[/TD]

[TD="class: xl63"]210046503[/TD]

[TD="class: xl68"]77[/TD]
[TD="class: xl68"]70[/TD]
[TD="class: xl68"]57[/TD]
[TD="class: xl68"]86[/TD]
[TD="class: xl68"]54[/TD]

[TD="class: xl63"]210250151[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]70[/TD]
[TD="class: xl68"]77[/TD]
[TD="class: xl68"]66[/TD]
[TD="class: xl68"]0[/TD]

[TD="class: xl63"]210099976[/TD]

[TD="class: xl68"]43[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]66[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]74[/TD]

[TD="class: xl63"]208204369[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]60[/TD]
[TD="class: xl68"]60[/TD]
[TD="class: xl68"]66[/TD]

[TD="class: xl63"]210225882[/TD]

[TD="class: xl68"]53[/TD]
[TD="class: xl68"]70[/TD]
[TD="class: xl68"]63[/TD]
[TD="class: xl68"]74[/TD]
[TD="class: xl68"]51[/TD]

[TD="class: xl63"]210230908[/TD]

[TD="class: xl68"]0[/TD]
[TD="class: xl68"]80[/TD]
[TD="class: xl68"]77[/TD]
[TD="class: xl68"]83[/TD]
[TD="class: xl68"]71[/TD]

 

[Logit]

.
Sounds like homework ?

https://support.office.com/en-us/ar...-a-range-45fe249f-96c3-443b-8e9f-87f16c48462c

Are you to find the highest score on each of three sheets ?

 

[BlackMane]

yep