Double Max Value

[thakali]

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.

 

[arthurbr]

Ypu can use a filter or the following technique https://fiveminutelessons.com/learn-microsoft-excel/use-index-lookup-multiple-values-list

 

[Aladin Akyurek]

In C1 just enter:

=MAX(A1:A10)

In C2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$C$1,ROW($B$1:$B$10)-ROW($B$1)+1),ROWS($C$2:C2))),"")

 

[kvsrinivasamurthy]

ARRAY formula in ROW 1 then drag down
ARRAY formula should be confirmed with Ctrl+Shift+Enter

=IFERROR(INDEX($B$1:$B$10,SMALL(IF(($A$1:$A$10)-(ROW($A$1:$A$10)*10^-6)=LARGE(($A$1:$A$10)-(ROW($A$1:$A$10)*10^-6),ROWS($A$1:$A1)),ROW($A$1:$A$10),""),1)-ROW($A$1)+1),"")

 

[thakali]

Thank you so much

 

[thakali]

thank you

 

[Aladin Akyurek]

@ thakali

You are welcome.