What if there are two or more teams tied for third place?

In article ,
"tagraeff" wrote:

Thank you for making this look so easy. I would have never figured it out.
I really appreciate your help.

"Mladen_Dj" wrote:


"tagraeff" wrote in message
...


I would like to show the name of the team (which is in column A) and
their
%
(which is in column N)
What formula, if any, do I use to do this?


For % of the team use LARGE function. For example in table with range A1:N9

=LARGE($N$1:$N$9;1) for top team,
=LARGE($N$1:$N$9;2) for second team,
=LARGE($N$1:$N$9;3) for third team.

To get names of teams use INDEX function:
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;1);$N$1:$N$ 9;0);1) for top team,
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;2);$N$1:$N$ 9;0);1) for 2nd,
=INDEX($A$1:$N$9;MATCH(LARGE($N$1:$N$9;3);$N$1:$N$ 9;0);1) for 3rd.