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.
LET
Assigns names to values or calculations to simplify formulas 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.
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.
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.
Shift Rows into Columns
Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.
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.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
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.
Subject Scores Transposition
Challenge No. 223: Transpose the problem table into result table.
Solved using: Python.
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.