View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steven.holloway steven.holloway is offline
external usenet poster
 
Posts: 26
Default 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