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.
|