find the nth occurrence from the bottom of a column

In this case what is the result as per your requirement

I have something that will do what you want, but it involves the use of helper columns (which you can hide if you want.

Assuming your data looks like this...

	A	B	C	D	E
1			TeamA	TeamB
2	teamA	playerA	1	0	playerD
3	teamA	playerB	2	0
4	teamB	playerC	2	1
5	teamA	playerD	3	1
6	teamB	playerE	3	2
7	teamA	playerF	4	2

E2=INDEX($B$2:$B$7,MATCH(LARGE($D$2:$D$7,1)+1,$C$2:$C$7,0))

Another way:

Row\Col	A	B	C	D
1	Team	Player
2	A	Abel	--	C2: =IF(COUNTIF(A$1:A2, A2) = COUNTIF($A$2:$A$7, "<>" & A2) + 1, "winner", "--")
3	A	Bill	--
4	B	Cain	--
5	A	Drew	winner
6	B	Eric	--
7	A	Fred	--

I knew there had to be a better way shg

I tried using subtotal/offset to create a single-cell formula, but didn't get there.

Edit: Oops, only did if for one side:

Row\Col	A	B	C	D
1	Team	Player
2	A	Abel	--	C2: =IF((COUNTIF($A$2:$A$11, A2) > COUNTIF($A$2:$A$11, "<>" & A2)) * (COUNTIF(A$1:A2, A2) = COUNTIF($A$2:$A$11, "<>" & A2) + 1), "winner", "--")
3	B	Bill	--
4	B	Cain	--
5	A	Drew	--
6	B	Eric	--
7	A	Fred	--
8	B	Gary	--
9	A	Hank	--
10	B	Ivan	winner
11	B	John	--
12

I was fiddling around with this (wasnt finished)...
=IF(COUNTIF($A$2:A2,C$1)-1=COUNTIF($A$2:A2,D$1),IF(COUNTIF($A$2:$A2,C$1)-D2>1,B2,""))
but yours is cleaner

Reckon I could eliminate some of the duplicate calculations ...

Row\Col	A	B	C	D
1	Team	Score
2	A	6		B2: =COUNTIF($A$5:$A$15, A2)
3	B	4		B3: =COUNTIF($A$5:$A$15, A3)
4	Winner	A		B4: =IF(B2>B3, A2, IF(B3>B2, A3, "draw"))
5	Team	Player
6	A	Abel	--	C6: =IF((A6 = $B$4) * (COUNTIF(A$5:A6, A6) = MIN($B$2:$B$3) + 1), "winner", "--")
7	B	Bill	--
8	B	Cain	--
9	B	Drew	--
10	A	Eric	--
11	A	Fred	--
12	A	Gary	--
13	B	Hank	--
14	A	Ivan	winner
15	A	John	--