Challenge No. 126: Work out the dates after the dates given in column A by Reference days.
Solved using: Power Query (Table.AddColumn).
⭐️⭐️ Easy
Slightly challenging problems for learners.
Find the first 50 Iccanobif numbers
Challenge No. 329: Find the first 50 Iccanobif numbers.
Solved using: Python.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Wildcard Pattern Matching Lookup
Challenge No. 125: Populate Output in T1 from T2.
Solved using: Power Query.
Column Splitting! Part 5
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
Find largest sum of contiguous cells
Challenge No. 320: Work out the largest sum for contiguous cells given in the range A2:A10.
Solved using: DAX.
Calculating Cumulative Debt
Challenge No. 55: Calculate Cumulative Debt
Previous day debt is to be cleared with current day budget There’s NO Excess Budget carry-over
e.
Solved using: Python.
Combining Tables
Challenge No. 54: Combine the tables
Repeat Items after every adjustment
Dynamic repeat of items for Every adjustment
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.