Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Carriage Return
Challenge No. 67: Split the data into separate rows
Combined data is separated by a carriage return
Not all rows have carriage returns
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Find Pythagorean Triplets
Challenge No. 484: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
Summarize Yearly Sales
Challenge No. 207: Generate the result table from problem table.
Solved using: Python in Excel.
Evaluate Concatenated Math Rows
Challenge No. 472: All rows carry one mathematical operator (to simplify only 4 basic maths operators which are +, -, * and / ).
Solved using: Python in Excel.
Custom String Sorting
Challenge No. 461: Sort the given strings as given in the answer.
Solved using: Python.
Extract Part and Date
Challenge No. 199: Extract part no.
Solved using: Python.
Longest Uppercase Substring
Challenge No. 458: Extract the substrings which have longest sequence of capital (uppercase) letters in given words.
Solved using: Python.