Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
Pivot Hierarchical Sublevels
Challenge No. 663: Pivot the data as shown.
Solved using: Power Query.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Percentage Share Per Group
Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.
Last Sundays Of Year
Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Perfect Square And Cube
Challenge No. 648: List the first 20 numbers which are both perfect square and perfect cube.
Solved using: Python.
Insert Quarterly Totals
Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.