Challenge No. 7: Return a Date given the Month, Year, Day of the Week and Occurrence Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Longest Palindromic Word
Challenge No. 47: Palindromes are those words which are same even when read from backwards.
Solved using: Python in Excel.
Traveling Salesman Problem
Challenge No. 90: The Traveling Salesman Problem (TSP) is a well-known problem in mathematics used to determine the optimal travel path that visits all cities exactly once with the minimum cost.
Solved using:Excel, Power Query, Python, and R.
Count Team Wins
Challenge No. 46: List the Teams and the number of matches won by them.
Solved using: Python in Excel.
Process Step Order Suffixing
Challenge No. 14: (Excel formulas also welcome)
A process gets executed in steps A through D in order (not all steps are necessary in the process but the order defines when the process has started and when it has ended.
Solved using: Power Query (Table.AddColumn, Table.AddIndexColumn).
Same Initial Letter Names
Challenge No. 45: Provide a formula to list the names where all words start with same alphabet.
Solved using: Power Query (Table.SelectRows).
Minimize Absolute Value Difference
Challenge No. 44: Find the numbers where absolute difference between Number1 and Number2 in a row is minimum.
Solved using: Python in Excel.
Return the Most Repeated Item in Columns
Challenge No. 6: Get the most popular fruit in the 5 stalls:
Rule: Strictly, Strictly Legacy array function or Power Query.
Solved using: Power Query.
List Candidates Matching Skills
Challenge No. 43: A1:C9: List of candidates with their primary and secondary skills.
Solved using: DAX.
Table Transformation! Part 9
Challenge No. 89: Product sales information is provided in the question table.
Solved using:Excel (COUNTA, FILTER, HSTACK), Power Query (List.Transform, Table.SelectRows, Table.Skip), Python, Python in Excel, and R.