Challenge No. 476: Divide the Sales from Table1 into Table2 equally over Stores.
Solved using: Python.
⭐️ Beginner
Easy challenges for newcomers.
Detect Wavy Number Pattern
Challenge No. 474: Wavy numbers – List the numbers where digits alternately get smaller or larger (they should not be equal).
Solved using: Excel VBA.
Create a Detailed Table
Challenge No. 65: Create the Detailed table from the Summary
e.
Solved using: Python.
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.
Decrypt Keyword Cipher Text
Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.
Sort Rows by Reference Column
Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
Solved using: Python in Excel.
Rank by Demand
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Mark Overlapping Time Ranges
Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.
Calculate Monthly Inventories
Challenge No. 463: Calculate the inventory at the end of all months of the year.
Solved using: Python in Excel.
Fill Missing Cells with Max
Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
Solved using: Python in Excel.