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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
List All Pronic Numbers
Challenge No. 276: List all Pronic numbers.
Solved using: Python in Excel.
Find Palindrome Words in Text
Challenge No. 275: A Palindrome word is that which is same even when read backwards.
Solved using: Python in Excel.
Concatenated Multiples All Digits
Challenge No. 274: List those numbers when a number is multiplied by 2 once and 3 once and we join the original number with results of these multiplications, then the result should contain all digits from 0 through 9.
Solved using: Python in Excel.
List Autobiographical Numbers
Challenge No. 273: List all numbers which are Autobiographical numbers.
Solved using: Python in Excel.