Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
MAP
Applies a function to each element of one or more arrays in Excel.
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
Match Reverse Word Containment
Challenge No. 264: Ananyms are words in reverse.
Solved using: Power Query.
Odd Even Min Max Split
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
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.
Decrypt Route Cipher
Challenge No. 258: Route Cipher Decryption – This time you would need to decrypt the given Encrypted text.
Solved using: Excel VBA.
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.
Strings With Asterisks Between Letters
Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.