Challenge No. 229: Find all double base Palindrome Numbers.
Solved using: Python in Excel.
CONCAT
Concatenates text from multiple cells without a delimiter in Excel.
Encrypt Using Affine Cipher
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
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.
Encrypt Using Date Cipher
Challenge No. 207: DATE CIPHER
Date cipher is a type of Caesar’s shift cipher where key is current date in YYYYMMDD format.
Solved using: Excel VBA.
Encrypt Using Baconian Cipher
Challenge No. 203: Baconian Cipher
(This problem is case insensitive)
A is 0, B is 1, C is 2.
Solved using: Power Query.
Column Splitting! Part 1
Challenge No. 136: Split the ID values where a character is repeated consecutively.
Solved using:Excel (CONCAT, DROP, IF), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Identify The Pattern !
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
List Tetradic Numbers
Challenge No. 183: List Tetradic numbers from column A.
Solved using: Python in Excel.