Return reference to second or third of identical maximum values

[excessi0n]

Hi,

I have a data set of a few hundred rows.

I have columns B to AH, the heading of each of which is a different sport.

In each row, an arbitrary number of columns have an integer value between 1 and 10 entered.

What I need to do is, in columns AJ onwards, return the four largest integers (very easy - LARGE())

But I also want to return the cell reference to these largest integers so I can report WHICH sport they refer to. Also very easy using MATCH() and INDEX(). Except for the case when two or more of the largest integers are the same. In this scenario I can only return the reference to the FIRST matching value. How can I return the reference individually for each of the largest cells?

For instance, what I want to get is this:

Please Login or Register  to view this content.

But all I've managed to get is this:

Please Login or Register  to view this content.

Thanks in advance for your advice.

James

[canapone]

Hi,

a possible solution

Please Login or Register  to view this content.

in AI3 and to the right.

Cheers

[canapone]

Hi again,

a small integration to get the values too

Please Login or Register  to view this content.

Cheers