Excel formula Challenge - Most country pairs in FIFA WorldCup Finals

Microsoft Excel challenge: This video breaks down an Excel formula challenge to find the teams that have played in the finals of the world cup the most, and have played more than once. It follows the problem systematically to a solution

00:00 Introduction
00:34 Reading the problem
01:16 brief description of solution approach
01:45 sorting a single row
02:29 BYROW to kick off solution
10:31 Sorting to achieve final result
11:21 Add a Unique to remove duplicates
11:40 Validating the result through tests

Link to Excel workbook:

Link to linkedin Challenge:

[IvanCortinas_ES]

Each challenge is more challenging than the last. Thank you Victor, another great explanation!!!!

[waitplanwp]

You will always be number 1, love everything you do for the channel, everything you solve is gold!

[wayneedmondson]

Another awesome solution! Thanks Victor!!

[sunnybaggu]

key points was
1.0 The use of TEXTJOIN with SORT for avoiding errors inside BYROW,
2.0 Use of worthy SUM function instead of countif (as arrays are not considered in countif)

Also till now i thought BYROW can handle single column, but you took it to the multiple columns.

So much worthy stuff this time.
Grateful and happy that i am a follower of your teachings here in YouTube.
Thank you Sir....looking for the next one.

[GrainneDuggan_Excel]

Mindblowing solution Victor! This is on my watch again list!

[pro]

I'll watch everything that came after about ten times;: Hello everyone, to try to learn something… Mister Momoh, you are skilled at making me feel bad!

[stevereed]

Thanks Victor, another masterclass. Very well explained.

[KevinPGA]

Beautiful explanation! I really enjoy hearing your thought process. Thank you for another extremely helpful video! 👍