Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
CHAR
Returns the character associated with a numeric code in Excel.
XOR Cipher for Message
Challenge No. 173: This time, in step 3 in place of adding both the numbers, we need to do Bitwise XOR operation.
Solved using: Power Query (List.Transform).
Find Missing Alphabets
Challenge No. 172: Find the missing English Alphabets from First Ladies column.
Solved using: Power Query.
Porta Cipher Grid Formula
Challenge No. 166: The grid shown is used in Porta Cipher for Cryptography.
Solved using: Python in Excel.
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
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).
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Caesar Cipher Multi Shift
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
Generate Tabula Recta Grid
Challenge No. 88: Generate the given grid.
Solved using: Python.