Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Sum-Based Neighboring Grid Fill
Challenge No. 532: Apologies!! Scheduling didn’t work today.
Solved using: Python in Excel.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Max Sale Date and Amount
Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Split Periods For The Project
Challenge No. 74: 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.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Calculate Shipped Fruit Value
Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Matching Digit Sums
Challenge No. 519: Find first 25 numbers starting with two digits where sum of individual digits of (Number = Square of Number = Cube of Number)
Ex.
Solved using: Python.