Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the next same rank in data
I will simplyfy my request to two columns of data; A containing a unique ID
and B containing random values (which can be duplicated). I want to extract the top 10 IDs based on their values, I was able to do this via an "index" on a "match" on a "large", but if I have two or more tieing entries, the first found ID is shown for all. Is there away to find (lookup or match) the next joint ranked item? Many thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transforming rank data | Excel Discussion (Misc queries) | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |