Get the top result from a countif

[Anglais428v2]

I have two tables see below:

Table1:

To	From
UK	Germany
UK	US
UK	Germany
UK	France
France	US
France	US
France	US
France	Germany
France	Germany

Then Table2 (including expected result):

Country	Top 'from'
UK	Germany
France	US

I need a formula to calculate the results 'Germany' and 'US' in Table2. The formula should look at the Country name in Table 2 (e.g. UK), go to Table1 and search for that country in the 'To' column, then return the 'from' country that has the highest number of results (in this case it would be 'Germany' as it occurs twice when the 'UK' is in the To column. Similarly for 'France' in the To column of Table 2, the result should be the US as it occurs three times in the From column of Table1.

Thanks

 

[RoryA]

What if there's a tie?

 

[Anglais428v2]

There is unlikely to be a tie, so I'd be happy with a false statement of something like "multiple locations". However, if it is possible to include the tied countries separate by a semi-colon that would be great.

 

[RoryA]

You could try something like:

=LET(totals,IF(Table1[To]=[@Country],COUNTIFS(Table1[To],[@Country],Table1[From],Table1[From]),0),TEXTJOIN(",",TRUE,UNIQUE(FILTER(Table1[From],totals=MAX(totals)))))

 

[Anglais428v2]

This is brilliant. Now I just have to break it down to see what is going on.
Many thanks