Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Recover Missing Cipher Keys
Challenge No. 253: NOTE – Order in answer is not important.
Solved using: Power Query (Text.Combine).
Convert Numbers to Expanded Form
Challenge No. 252: Write the numbers in expanded form.
Solved using: Python in Excel.
Digit Rearranged Multiplication Match
Challenge No. 251: Find those numbers which when multiplied by 2 to number of digits in that number generates the same digits in any other order.
Solved using: Power Query.
Classify Password Strength
Challenge No. 250: Classify the given passwords as
Invalid – If less than 8 characters
If >= 8 Characters
Weak – Contains only alphabets or only numbers or only special characters
Strong – Contains either alphabets+numbers or alphabets+special characters or numbers+special characters
Very Strong – Contains all 3 i.
Solved using: Excel VBA.
Multiply Digits to Single Digit
Challenge No. 249: Multiply first digit with second digit, then result of this should be multiplied with 3rd digit and so on.
Solved using: Power Query.
Month and Quarter by Index
Challenge No. 248: Print the name of month & quarter as per position of 1.
Solved using: Power Query.
Case-Sensitive Reverse Cipher
Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.
Sort Words by End Digit
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Identify Diamond Strings
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.