Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank(A1,C1:C5) - Rank using 2 ranges | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |