Challenge No. 55: Provide a formula to generate the given grid.
Solved using: Power Query.
⭐️⭐️ Easy
Slightly challenging problems for learners.
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.
Check Word Anagram Pair
Challenge No. 50: An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.
Solved using: Power Query.
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).
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.
Find Common Letters Between Words
Challenge No. 40: Provide a formula to find common unique alphabets between 2 cells in same row.
Solved using: Power Query.