Challenge No. 698: Populate all months of the year.
Solved using: Python.
LOOKUP
Finds a value in a one-row or one-column range in Excel.
Find Project Critical Path
Challenge No. 656: This challenge is contributed by Abdelrahman Omer, MBA, PMP
Find the critical path and its duration for this project.
Solved using: Python.
Find Immediate Previous Caller
Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Sum of Odd Numbers Sequence
Challenge No. 522: Check if a number can be expressed as a sum of consecutive odd numbers.
Solved using: Python in Excel.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.