Challenge No. 234: Find the numbers which are divisible by their individual digits.
Solved using: Python in Excel.
MID
Extracts a substring from a text string at a given position in Excel.
Check Pandigital by Base
Challenge No. 231: List Yes if a Number is Pandigital number in a given base else No.
Solved using: Power Query.
Find Double Base Palindromes
Challenge No. 229: Find all double base Palindrome Numbers.
Solved using: Python in Excel.
Encrypt Using Affine Cipher
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
Even Result by Position Sum
Challenge No. 224: List the numbers where following result is an even number
Result = Sum of Digits at Odd positions – Sum of Digits at Even positions
Positions start at 1 not at 0.
Solved using: Python in Excel.
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.
Number Each Character
Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).
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.