Challenge No. 124: Calculate the Network Days Count between given Months.
Solved using: Python in Excel.
List numbers not in Fibonacci sequence
Challenge No. 326: List the numbers which are not a Fibonacci number.
Solved using: Python in Excel.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Table Transformation! Part 24
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Split Time into Weekly Blocks
Challenge No. 123: Calculate Start and Finish date times along-with duration in hours for all weeks.
Solved using: Python in Excel.
List subjects appearing within +/-1 row in column B
Challenge No. 324: List the subjects from column A which appear in column B within +1 or -1 position to column A.
Solved using: DAX.
Find palindromic substrings with at least 3 digits
Challenge No. 323: Find the substrings of given numbers which are Palindromic.
Solved using: DAX.
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.
Calculate Vehicle Daily Usage
Challenge No. 122: Transform the problem table into result table and work out the total number of hours a vehicle has run on a particular date.
Solved using: Power Query (List.Transform).
Top 3 employees nearest to average salary
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.