Usage of new functions Filter and Sort with Dynamic Arrays in Excel; using FMWC Dominoes case for example data

Description
This Best Practice demonstrates some techniques with new features and functions in MS Excel: Dynamic Arrays, LET, SORT and FILTER functions in combination with INDEX to extract single rows or columns from an array. The demo provides a solution to a case that was presented in the Excel as Esports games at Financial Modelling World Cup for input and demo data.
Instructions for the aim and rules of the game are found on the Case sheet in the Excel file.

The solution simulates 5 moves in a Domino game with given sequence for dealing of the domino tiles. In each move each player's deck needs to be evaluated for a tile to be added to the line on the table taking into account also different options for a move

1) the player has more than one tile in his deck that matches all criteria for the line on the table
2) the player has a tile in hand he could add on both sides of the line
3) the player has no matching tile in his deck, and has to draw the next tile from the heap
3a) after drawing another tile from the heap the player can add the tile
3b) after drawing another tile from the heap the player still has no matching tile in hand.

You need to use a current Excel version (best Excel 365) to have these features and functions in place and working.