| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieving top/bottom n rank()-ed data
I have a table in which one column (say A) contains unsorted numeric values
and another column (say B) contains the values returned by =rank() based on those numeric values. In cases where those numeric values in col A are not unique, the ranks in column B will contain duplicates as well. I want to find a way to extract the top ranking n numeric values and the bottom ranking m numeric values WITHOUT HAVING TO SORT THE TABLE. Is there an (easy) way to do that? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Retrieving data from the web - help ! | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) | |||
Threaded Mode
