I have a data table from column A-D. I want to identify the category in which each student has highest marks.
For some data manipulation purpose, I would like to have the category printed on a row which had the highest marks for a particular student.
Attached is my data table and I have manually typed the end result that I want to achieve by formula. Please note that there are varying rows as per students, E.g. Alex has 3 rows, Bob has 2 and Kim has 4. If the formula can print the result in a same row which had highest marks per student it would be great.
Appreciate your time.