Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Transpose Team Problem Table
Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).
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.
Sort Words By Embedded Numbers
Challenge No. 277: All words have an one digit number within themselves.
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.
Extract From Text! Part 5
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Odd Even Min Max Split
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Table Transformation! Part 18
Challenge No. 157: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, INDEX, LAMBDA), Google Sheets, Power Query (List.Split, List.Transform, Text.Split), Python, Python in Excel, and R.