Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Interleave Numbers into Letters
Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
Presidents with Same Initials
Challenge No. 504: List those presidents’ names whose first characters of all parts of names are same.
Solved using: Excel VBA.
Aggregate Customer Purchase Stats
Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
Normalize Staff Entries
Challenge No. 219: Normalise the table as shown.
Solved using: Python.
List WC Champion Years
Challenge No. 498: Align the soccer WC champions year wise (year in descending order).
Solved using: Python in Excel.
Repeat Pythagorean Triplet Finder
Challenge No. 491: 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.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.