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.
Process Time Running Totals
Challenge No. 98: 1.
Solved using: Python.
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.
Lookup and Sum
Challenge No. 44: Summarise the budget per Department
For example, Using the Lookup table, the total Finance budget is
“Treasury (278)+Budgeting (748)”.
Solved using: Python.
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.