Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Perfect Square Predecessor Checker
Challenge No. 517: Arrange the given numbers in such a fashion that sum of preceding + current number is a perfect square.
Solved using: Python in Excel.
Sum Sales By Month
Challenge No. 230: Summarize the table as shown by summing up Sales against each month.
Solved using: Python in Excel.
Smallest Product Digit Number
Challenge No. 516: Find the smallest numbers whose product of digits is equal to numbers in column A.
Solved using: Python in Excel.
Create Weekly Group
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.
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.
Sort by Unit Digit
Challenge No. 513: Sort the numbers on the basis of unit digit (last digit).
Solved using: Python.