Challenge No. 72: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
LAMBDA
Creates custom reusable functions in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Max 2×2 Grid Sum
Challenge No. 514: Find the 2×2 grids in the given 5×5 grid where sum is the maximum.
Solved using: Python in Excel.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.
Find Next Sparse Number
Challenge No. 512: A number is called a Sparse number if its binary form doesn’t have any two adjacent 1s.
Solved using: Python in Excel.
Shift Rows into Columns
Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
Extract and SuM
Challenge No. 71: Extract the buying and selling prices, then calculate profit/loss.
Solved using: R.
Sum Pascal Triangle Columns
Challenge No. 509: A Pascal Triangle starts with 1 at the top and each element is sum of two upper diagonal cells.
Solved using: R.
Perfect Square with Digit-Square Sum
Challenge No. 508: List first 500 numbers (skip single digit numbers) where number is a perfect square and also sum of squares of its digits is also a perfect square.
Solved using: Python in Excel.