Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Resetting Running Totals
Challenge No. 51: Calculate running totals for defective free units
Running Total resets to ZERO with each defection noted
For example, on the 14th, the running total is 214 since we have defects on the 13th
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Prime After Digit Removal
Challenge No. 303: Remove the digits in each position and list those numbers which are prime for all occurrences of removal.
Solved using: Python in Excel.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Summarize Hours by Role Title
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Generate Vigenere Cipher Grid
Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
List the Polydivisible numbers
Challenge No. 301: List the Polydivisible numbers.
Solved using: Python in Excel.
Hierarchical Structure!
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Sort and Position Team Members
Challenge No. 111: Fill in the individuals in Ind columns and their positions in Team Members in Ind_Pos columns.
Solved using: Python in Excel.
Fill Grid Skipping Values
Challenge No. 300: Fill in 10×8 grid with numbers sequentially skipping X.
Solved using: Python in Excel.