MODE for Text including Count IF...HELP!

[apatheticrory]

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

	Year	Q1	April
Busiest Team	A
Most Common Nat	B
Most Common Nat exc GBR
Most Common Nat (Alpha Team)
Most Common Nat exc GBR (Alpha Team)
Most Common Nat (Bravo Team)
Most Common Nat exc GBR (Bravo Team)
Most Common Nat (Charlie Team)
Most Common Nat exc GBR (Charlie Team)

<tbody>
</tbody>

The Cell in which i have entered A contains the following formula:

Code:
=INDEX(Data!D2:D20,MATCH(MAX(COUNTIF(Data!D2:D20,Data!D2:D20)),COUNTIF(Data!D2:D20,Data!D2:D20),0))
The cell in which i have entered B contains the same but with the Column changed to incorporate the Nationality not the Team.

The data on which this is produced is a simple sheet as follows:

Date	Quarter	Month	Team	Nationality
01/01/2017	4	1	Alpha	GBR
01/04/2017	1	4	Charlie	USA

<tbody>
</tbody>

</body>Hopefully someone can help me fill in the blank cells in the below table? I am trying to create a sheet to collate application stats for a few teams....

	Year	Q1	April
Busiest Team	A
Most Common Nat	B
Most Common Nat exc GBR
Most Common Nat (Alpha Team)
Most Common Nat exc GBR (Alpha Team)
Most Common Nat (Bravo Team)
Most Common Nat exc GBR (Bravo Team)
Most Common Nat (Charlie Team)
Most Common Nat exc GBR (Charlie Team)

<tbody>
</tbody>

The Cell in which i have entered A contains the following formula:

[COLOR=#333333]=INDEX(Data!D2:D20,MATCH(MAX(COUNTIF(Data!D2:D20,Data!D2:D20)),COUNTIF(Data!D2:D20,Data!D2:D20),0))[/COLOR]

The cell in which i have entered B contains the same but with the Column changed to incorporate the Nationality not the Team.


The data on which this is produced is a simple sheet as follows:

Date	Quarter	Month	Team	Nationality
01/01/2017	4	1	Alpha	GBR
01/04/2017	1	4	Charlie	USA

<tbody>
</tbody>

 

[Aladin Akyurek]

Try to post input which correlates to the output that is desired. Try also to avoid describing the problem to solve by means of Excel formulas.