Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
By Topic
Challenges categorized by topic.
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.
Index-wise Base Encoding Sort
Challenge No. 527: Convert every digit from right to left in the base of its index + 1 reading index 1, 2.
Solved using: Python.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
List Dates with Unique Digits
Challenge No. 521: List all dates containing unique digits between 1900-01-01 to 2999-12-31.
Solved using: Python in Excel.
Repeat Rows Until Next Date
Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.
Rank by Student Grade
Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
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.