finding the 5 largest numbers in a range

  • Thread starter Thread starter eightwgt
  • Start date Start date
E

eightwgt

Hello -

I have a problem.....

I have a spreadsheet and want to find the top 5 figures (largest) fro
a range of figures.

Column A = Name
Column B = user input 1
Column C = User input 2
Column D = Sum B + C

There are 50 rows

Need to list top 5 figures of the range D1..D50 AND list the Name fiel
associated with them -

PLEASE help !:confused
 
How about applying Data|filter|autofilter?

Then use the column D and filter on Top 10 (and make it top 5).
 
E1: 1
F1: =INDEX($A$1:$A$50,MATCH(G1,$D$1:$D$50,0),1)
G1: =LARGE($D$1:$D$50,E1)

Highlight E1:G1 and fill it down 4 more rows.

MATCH function returns only the first name if there is more than one person
with same score.
 
Back
Top