NUMBERS: How do I add the names of second and third place getters to cells?

One way is to do something like this:

I added a Rank column in Table 1, with this in C2, filled down:

=RANK(B2,B,0)

In the second table, 1 2 3 filed in by hand in A.

In B2, filled down:

=XLOOKUP(A2,Table 1::C,Table 1::B)

In C3, filled down:

=XLOOKUP(A2,Table 1::C,Table 1::A)

Note that the modern XLOOKUP function (easier to use than the old VLOOKUP) has similar functionality to INDEX MATCH.

XLOOKUP - Apple Support

You might also consider just adding the extra column in Table 1 and sorting on it (click the column letter and choose Sort Descending from the dropdown). Then you don't need the second table. And if there is a tie you will see both players.

SG

These two formulas should be what you are looking for

The first in table 2 in B2 then drag it down

=INDEX(Table1::$CATCHES;RANGE(Table1::CATCHES;Table1::CATCHES;1))

The second in table 2 in C2 then drag it down

=XLOOKUP(B2;Table1::CATCHES;Table1::NAME;;;)

seavalley wrote:

It was working well until 2 players had the same number of catches.....

Yes, that's the problem with a "tie" that I mentioned in my post above. That is why I prefer just a simple sort on the added Rank column in Table 1.

SG

You're right.

I did some tests and I propose this solution

Add a column to table 1 and in C2 put the following formula that allows you to have a ranking without double positions

=COUNTIF(CATCHES;”>"&B2)+COUNTIF(B$2:B2;B2)

Then drag it down

In table 2 in A2 I inserted this formula that dynamically gives me back the first positions of the ranking

=RANK(B2;Table1::CATCHES;)+COUNTIF('Table 2-1'::B$2:B2;'Table 2-1'::B2)−1

I did it by entering a custom format, but instead of 1° you can simply leave 1

In B2 I put this formula that gives me back the highest scores

=LARGE(Table1::CATCHES;RIGHE(B$2:B2))

In C2 there is this formula

=XLOOKUP(A2;Table1::C;Table1::NAME;;;)

sorry! translation error the function is not RANGE, but RANK

Dubbia wrote:

sorry! translation error the function is not RANGE, but RANK

I posted a reply using RANK. Have you seen it?

SG

I now see your proposal, but the correction concerns my proposal where I made a mistake by writing range instead of rank.