get top 3 score plus name in another cell

as the title says I need to get the top score plus name of team

so i have  

Caterham     57
McLaren      67
Toro Rosso  23
McLaren      23
Williams     24
Ferrari         56

so ideally I would love

McLaren       67
Caterham     57
Ferrari          56
LVL 31
James MurrellProduct SpecialistAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
nutschConnect With a Mentor Commented:
Use

=LARGE($B$1:$B$6,1)
=LARGE($B$1:$B$6,2)
=LARGE($B$1:$B$6,3)

to get the largest scores, then this to return the team
=INDEX($A$1:$A$6,MATCH(LARGE($B$1:$B$6,1),$B$1:$B$6,0))
=INDEX($A$1:$A$6,MATCH(LARGE($B$1:$B$6,2),$B$1:$B$6,0))
=INDEX($A$1:$A$6,MATCH(LARGE($B$1:$B$6,3),$B$1:$B$6,0))
0
 
James MurrellProduct SpecialistAuthor Commented:
Your a superstar - Thanks
0
All Courses

From novice to tech pro — start learning today.