Getting the top 5

[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

 

[Ron]

Thanks Simon, I get a #VALUE error when I try this. Could the kind of data be
the problem?

 

[Ragdyer]

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))

 

[Ron]

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?

 

[Ragdyer]

Enter in B1:

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

And copy down.

 

[Ron]

PERFECT! Thank you for the expounded explanation. It works just the way I had
hoped.
Ron

 

[Ragdyer]

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>

 

[Shane Devenshire]

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.