Challenge No. 262: List the dates in YYYY-MM-DD format from 21st century i.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.
Generate Sequential Number Grid
Challenge No. 260: Generate the grid as per number given in cell A1.
Solved using: Excel VBA.
Replace Repeated Letters
Challenge No. 259: If an alphabet appears more than once, replace is with “)” otherwise replace it with “(“.
Solved using: Excel VBA.
Count of People by Age Group
Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
Decrypt Route Cipher
Challenge No. 258: Route Cipher Decryption – This time you would need to decrypt the given Encrypted text.
Solved using: Excel VBA.
Table Transformation! Part 18
Challenge No. 157: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, INDEX, LAMBDA), Google Sheets, Power Query (List.Split, List.Transform, Text.Split), Python, Python in Excel, and R.
Extract Vowels with Positions
Challenge No. 256: Extract the vowels and their positions within the string.
Solved using: Excel VBA.
Find All Happy Numbers
Challenge No. 255: List all the Happy numbers.
Solved using: Excel VBA.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.