Challenge No. 17: (Excel formulas also welcome)
Generate the output table.
Solved using: Power Query.
By Topic
Challenges categorized by topic.
Reverse Lookup
Challenge No. 9: Reverse Lookup of all the scheduled jobs, Dates and Time
Strictly Legacy Array Functions or PowerQuery.
Solved using: Python.
Missing Values! Part 3
Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
Create Number Blocks From a Text String
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
Sum Tenure of US Presidents
Challenge No. 51: Provide a formula to calculate the total (sum) years of tenure of all US presidents.
Solved using: Power Query.
Split and Sum a Text String Using a Criteria
Challenge No. 10: Sum only quantities above 100
Strictly use the Legacy array function or Power Query.
Solved using: Power Query.
Return a Date given the Month, Year, Day of the Week and Occurrence
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.
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.
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.