Solved

get top 3 score plus name in another cell

Posted on 2014-03-13
2
176 Views
Last Modified: 2014-03-13
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
0
Comment
Question by:James Murrell
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
Comment Utility
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
 
LVL 31

Author Closing Comment

by:James Murrell
Comment Utility
Your a superstar - Thanks
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now