Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Convert Roman to Decimal
Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.
Extract Running Total By Group
Challenge No. 43: Generate result table as shown.
Solved using: Excel VBA.
Common Digits in Row
Challenge No. 151: List the common digits between all the numbers in a row.
Solved using: Python in Excel.
Perfect Numbers Detection
Challenge No. 149: List the perfect numbers from column A.
Solved using: Python in Excel.
Rotate Grid by Count
Challenge No. 148: Rotate the grid given in A4:E7 as per values given in B1.
Solved using: Power Query.
Check Narcissistic Numbers
Challenge No. 147: A Narcissistic number is that number which is the sum of nth powers of its digits where n is the length of the number.
Solved using: Python in Excel.
List All Pangram Sentences
Challenge No. 146: A Pangram (also known as Holoalphabetic) sentence is that which contains all 26 letters of English alphabets at least once.
Solved using: Power Query (Table.SelectRows).
Right Strip Given Chars
Challenge No. 145: Remove RSTRIP Chars from Input String from right side.
Solved using: SQL.