Challenge No. 698: Populate all months of the year.
Solved using: Python.
XLOOKUP
Searches a range for a value and returns a corresponding result 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.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
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.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.
Merge Tables by Org and Year
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Distribute Sales Equally
Challenge No. 476: Divide the Sales from Table1 into Table2 equally over Stores.
Solved using: Python.