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.
List Repeated Column Words
Challenge No. 257: List those words which get repeated in a column.
Solved using: Python in Excel.
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.
Check Date Within Name Range
Challenge No. 86: In result table, populate Y and N against the names given in T1.
Solved using: Power Query (Table.SelectRows).
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.
Column Splitting! Part 3
Challenge No. 156: If the IDs contain an even number of characters, split them into two columns at the midpoint.
Solved using:Excel (HSTACK, IF, IFNA), Google Sheets, Power Query (List.Transform, Text.End, Text.Start), Python, Python in Excel, and R.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
Strings With Asterisks Between Letters
Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.