View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default Location of n-th highest value in the range

You may try the following:
=MATCH(LARGE(A1:A50,5),A1:A50)
This will find the 5th largest number in the A1:A50 range and return its
position. You may substitute the parameters to fit you case.

Hope this helps,
Miguel.

"Oscar" wrote:

How can I get location of n-th highest (parameter) value in the range of
values. In case of equal values I want first occurance to be higher ranked.

Thanks, Oscar.