![]() |
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 |
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