Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
VSTACK
Stacks arrays vertically into a single column in Excel.
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.
Remove Digits for Largest Cube
Challenge No. 502: For the largest cube number by removing minimum number of digits.
Solved using: Python in Excel.
Find Row/Col Consecutive Numbers
Challenge No. 501: In the given grid, find the numbers which are consecutive either column wise or row wise (not diagonal wise).
Solved using: Python.
Extract Entries from Running Total
Challenge No. 500: Get the individual entries from the running total which is across the row and continues to the next rows.
Solved using: Python.
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.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.