Challenge No. 45: Extract the Date and Amount from the details
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: Python.
DROP
Removes a specified number of rows or columns from an array in Excel.
Reduce to Single Digit by Difference
Challenge No. 278: Reduce the number to a single digit number by repeatedly subtracting the adjacent digits.
Solved using: Python in Excel.
Remove Consecutive Repeated Digits
Challenge No. 269: Remove consecutive digits from the number.
Solved using: Excel VBA.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Custom Grouping! Part 11
Challenge No. 161: Extract the list of dates associated with each product and display them under each other in separate columns.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Filter Last Transaction!
Challenge No. 158: From the question table, extract the last transaction per product for each month.
Solved using:Excel (DROP, FILTER, GROUPBY), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Combine), Python, Python in Excel, and R.
Count of People by Age Group
Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
Strings With Asterisks Between Letters
Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
Table Transformation! Part 17
Challenge No. 155: Transform the question table into the result table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Skip, List.Transform, Table.AddColumn), Python, Python in Excel, and R.