Challenge No. 467: If tasks’ From Time and To Time overlap with each other, mark them as Y.
Solved using: Python in Excel.
VSTACK
Stacks arrays vertically into a single column 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.
Merge Subject Maximum Marks
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Common Entries and Count
Challenge No. 453: Today’s challenge is contributed by Mehmet Çiçek
Find the common entries in List1 and List2 and common count.
Solved using: Excel VBA.
Max Consecutive Number Streak
Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.
Reverse Cumulative Row Sums
Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.
Group and Sum
Challenge No. 59: Group and Sum Shop Fruit Sales
e.
Solved using: R.
Unstack Groups for Summation
Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.