Getting the top 5

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have 48 percentage entries in one row. In the next row, I would like to
list the top 5 percentages. It doesn't matter if some are the same
percentage. Can someone help me please? Thank you
 
Say your values are in A1 to AV1.

Enter this formula anywhere, and copy across as many columns as you wish to
see results:

=LARGE($A$1:$AV$1,COLUMNS($A:A))
 
Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5
in B1 to B5. Now what do I do?
 
You're very welcome, and appreciate the feed-back ... although I didn't
think that I explained anything, much less elaborated it enough to have it
labeled as an expounded explanation.<bg>
 
Based on the location of your data and formulas, this is a shorter solution:

=LARGE(A$1:A$25,ROW())

ROW() return the row number of the formula, in this case 1 in B1.
 
Back
Top