Challenge No. 47: Add the opening stock to each recorded stock during the day
Note that this is not a running total but a stock adjustment
For example, the last recording on the 10th is 201, i.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
Generate Demlo Numbers diamond
Challenge No. 285: Generate Demlo Numbers diamond.
Solved using: R.
Find Divisible Substrings Sorted
Challenge No. 281: List all the substrings from Number1 which are divisible by Number2.
Solved using: Python in Excel.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Data Extraction
Challenge No. 45: Extract the Date and Amount from the details
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: Python.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
Reduce to Single Digit by Difference
Challenge No. 278: Reduce the number to a single digit number by repeatedly subtracting the adjacent digits.
Solved using: Python in Excel.
Sort Words By Embedded Numbers
Challenge No. 277: All words have an one digit number within themselves.
Solved using: Python in Excel.
Table Transformation! Part 19
Challenge No. 167: Transform the question structure into the result structure.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Skip, List.Split, Table.AddColumn), Python, Python in Excel, and R.
List All Pronic Numbers
Challenge No. 276: List all Pronic numbers.
Solved using: Python in Excel.