Find top 5 highest values/percentage within a table

  • Thread starter Thread starter Tobias
  • Start date Start date
T

Tobias

Hello!

I have two different excel sheets. In one of them, I have a big table of
around 40-50 names and percentages. I want to find the top 5 highest values
in one column from the other excel sheet and from there get the numbers and
text that in the same row. Any ideas of how it could be done?

Thanks in advance,
Tobias
 
You can use Large function to return top 5 values in a column. For example :
=LARGE(A1:A50,5) this willl return the 5th largest value from the range
A1:A50. Then you can use VLOOKUP to return the corresponding names.
 
Sheet2!A1: =LARGE(Sheet1!A:A,1)
Sheet2!B1: =VLOOKUP(A1,Seet1!A:B,2,False)

Sheet2!A2: =LARGE(Sheet1!A:A,2)
Sheet2!B2: =VLOOKUP(A2,Seet1!A:B,2,False)

etc.
 
Back
Top