Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.
Transpose Vertical to Horizontal
Challenge No. 202: Transpose the problem table into result table.
Solved using: R.
List Bouncy Numbers
Challenge No. 466: A Bouncy number is any non-negative integer that is neither increasing nor decreasing.
Solved using: Excel VBA.
Task Assignment Load Balancing
Challenge No. 465: There are 4 persons who can be a candidate to do a task.
Solved using: Python in Excel.
Map Buyer Purchase Dates
Challenge No. 201: List what items each of the buyers bought? Table2 is for availability dates of the items during which items could have been bought.
Solved using: Python in Excel.
List Palindromic Evil Numbers
Challenge No. 464: Work out the first 1000 Evil Numbers (at least 2 digits) which are Palindromic also.
Solved using: Python in Excel.
Calculate Monthly Inventories
Challenge No. 463: Calculate the inventory at the end of all months of the year.
Solved using: Python in Excel.
Merge Subject Maximum Marks
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Fill Missing Cells with Max
Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
Solved using: Python in Excel.
Custom String Sorting
Challenge No. 461: Sort the given strings as given in the answer.
Solved using: Python.