Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Find Monthly Min Max Dates
Challenge No. 99: Find when the Min and Max occurred for various months and corresponding dates.
Solved using: Power Query (Text.Combine).
Data Extraction
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.
Reverse Only Vowels in Word
Challenge No. 279: Reverse only the vowels in the given words.
Solved using: Python in Excel.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
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.
Sort Words By Embedded Numbers
Challenge No. 277: All words have an one digit number within themselves.
Solved using: Python in Excel.
Table Transformation! Part 19
Challenge No. 167: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, and R.
Fill Grid With Left Values
Challenge No. 97: Fill in the grid with the immediate non-blank value on the left.
Solved using: Excel VBA.
List All Pronic Numbers
Challenge No. 276: List all Pronic numbers.
Solved using: Python in Excel.