ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pulling top 5 rank? (https://www.excelbanter.com/excel-worksheet-functions/133245-pulling-top-5-rank.html)

[email protected]

Pulling top 5 rank?
 
Hey,
I have a list something like this:

# Variable Mean Rank 1 Mean 2 Rank 2 Mean 3 Rank
3

Is there any easy way to pull out the top 5 ranks from a list of
100+?

Thanks


MartinW

Pulling top 5 rank?
 
Hi,

Have a look at the LARGE function in the help file.
Others that are similar and worth checking out are
RANK and PERCENTILE, not what you need here
but worth knowing about.

You may also want to look at the DataSort tools.

HTH
Martin




All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com