Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.
CODE
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.
Case-Sensitive Reverse Cipher
Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.
Decrypt Polybius Cipher Grid
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Incremental Caesar Cipher
Challenge No. 236: We had 3 challenges on Caesar’s Cipher (if you are unaware about Caesar’s Cipher, I will encourage you to visit previous challenge to get an idea)
This is a variation of Caesar’s Cipher.
Solved using: Power Query (List.Transform).
Encrypt Using Affine Cipher
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
Calculate Name Numerology
Challenge No. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
Apply ATBASH Cipher Rules
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
Case-Sensitive Baconian Cipher
Challenge No. 212: (Baconian Cipher – This problem is case sensitive)
A/a is 0, B/b is 1, C/c is 2.
Solved using: Power Query.