
Publication number: ELQ-62653-1
View all versions & Certificate

Usage of new functions Filter and Sort with Dynamic Arrays in Excel; using FMWC Dominoes case for example data
Demo Solution to Level 5 in FMWC case "Dominate the Dominoes" with Dynamic Arrays, SORT, FILTER and LET function.
Further information
Demonstrate
separation of characters from unicode string of symbols into single symbol per cell
Filter and Sort functions and how to:
- combine with TRANSPOSE function
- get first result from a sort only,
- extract single columns from array
- gradually add more entries
- use entries to create a chain of tiles, and others.