Challenge No. 204: For a column, find how many members of the column are contained in other columns.
Solved using: Python.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Average Between Blank Groups
Challenge No. 203: Prepare the groups which lie between two blank Amount1s and give the average of numbers appearing in those groups (groups shaded in light red).
Solved using: R.
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.
Extract Part and Date
Challenge No. 199: Extract part no.
Solved using: Python.
Transpose Marks with Subjects
Challenge No. 196: Transpose the problem table into result table.
Solved using: Python in Excel.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.