Challenge No. 202: Transpose the problem table into result table.
Solved using: R.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
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.
Fill Missing Cells with Max
Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
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.
Parasitic Number Identification
Challenge No. 452: Parasitic number – is a positive natural number which, when multiplied by single digit n, results in movement of the last digit to its front.
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.
Rank Sales with Tie Handling
Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.