Hello guys
Column A has the marks obtained by the students whilst column B has the name of the students.
Two student have scored the same highest mark.
Now I want to know how can i find the name of the two students who have scored the same highest marks.
When I use "=VLOOKUP(MAX(A1:B10),A1:B10,2,0)", it only shows one student name but not the other. Can someone please help me with this.
Thank you in advance.
Column A has the marks obtained by the students whilst column B has the name of the students.
Two student have scored the same highest mark.
Now I want to know how can i find the name of the two students who have scored the same highest marks.
When I use "=VLOOKUP(MAX(A1:B10),A1:B10,2,0)", it only shows one student name but not the other. Can someone please help me with this.
Thank you in advance.