Matching top x results from a cell range and returning value from another column

[paul2342]

Hi everyone,
Is there a way to adjust this formula slightly so that it can 'cope' if there are values that are the same in a list.

The idea is the top 5 largest values and their matching names like this below:

This is the source data example (taking the 1st and 2nd largest entries - this is the source for example, below):

and this is the lookup formula / sheet which looks it up from (I made a copy of it from the other one which is which the column letters are different).

This is the formula:

=INDEX('Top long movers (don''t touch)'!$G$4:$G$160, MATCH(LARGE('Top long movers (don''t touch)'!$J$4:$J$160, E10), 'Top long movers (don''t touch)'!$J$4:$J$160, 0))

The challenge is, if there's two entries with the same return value, I'd like the formula to show them both (I guess they are 'joint place" number "1"), so I am trying to get it to show then like this (or vice versa), as "Oil & Gas Drilling" and "Industrial Gases" are in 'joint' 1st place ?

Any help is greatly appreciated,

Best Regards,
Paul

 

[sijpie]

In column K put the following formula:
=J4-ROW()/10000
copy down.

Now you have a list where two equal numbers in column J have a slight difference in column K.
So in your
=INDEX('Top long movers (don''t touch)'!$G$4:$G$160, MATCH(LARGE('Top long movers (don''t touch)'!$J$4:$J$160, E10), 'Top long movers (don''t touch)'!$J$4:$J$160, 0))

you replace the $J with $K

Then hide column K

 

[paul2342]

Many thanks Sijpie