Challenge No. 311: Sort the digits of given numbers in column A in descending order.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
Find the next 3 Friday the 13th dates
Challenge No. 310: Find the next 3 Friday the 13th dates for dates given in column A.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Condition Formatting Headers
Challenge No. 52: Condition Format the Header Of Each Group
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
List all Palindromic phrases
Challenge No. 307: List all Palindromic phrases.
Solved using: Python in Excel.
Rank Teams by Total Points
Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python 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.
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.
Fill Grid Skipping Values
Challenge No. 300: Fill in 10×8 grid with numbers sequentially skipping X.
Solved using: Python in Excel.