Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Align Custom Data Layout
Challenge No. 686: This problem is contributed by RIJESH THOMAS
Align the data as shown.
Solved using: Python in Excel.
Calculate Level Hierarchy Totals
Challenge No. 672: Level 1 is sum of Level 2.
Solved using: R.
Draw Alphabet Z Pattern
Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
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.
Align WBS Hierarchy Data
Challenge No. 645: Today’s challenge is contributed by Ahmad Syawal Ramli.
Solved using: Python.
Swap Number Sequences
Challenge No. 643: Replace next set of numbers with previous set of numbers and first set of numbers will be replaced by last set of numbers.
Solved using: Python in Excel.
Find Immediate Previous Caller
Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.
Build Alphabet Staircase Shape
Challenge No. 627: Create alphabets staircase as shown.
Solved using: Excel VBA.
Count Consecutive Number Repeats
Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.