Pulling top 5 rank?

T

takingchances

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
 
M

MartinW

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 Data>Sort tools.

HTH
Martin
 
Top