Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
Matrix Transformation Series
Challenge No. 661: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Converts the T1 matrix to a T2 matrix and the T2 matrix to a T3 matrix.
Solved using: Excel.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Cube With Equal Digits
Challenge No. 659: Find those 2 digits to 5 digits numbers whose cube results into numbers where frequency of appearing digits are same.
Solved using: Python.
Largest Alternating Digit Substring
Challenge No. 657: Find the largest substring number which has alternating odd/even or even/odd digits.
Solved using: R.
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.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Percentage Share Per Group
Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.