Challenge No. 234: Find the numbers which are divisible by their individual digits.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays 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.
Validate Multi-Word Names
Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
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.
Classify Deficient Perfect Abundant
Challenge No. 228: Take a positive integer n and add its positive divisors (let’s denote it by S)
Classify the numbers as per given criteria:
If S < 2n = Deficient Number
If S = 2n = Perfect Number
If S > 2n = Abundant Number
Ex.
Solved using: Python in Excel.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
Sort Numbers Leave Text
Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.
Find Kangaroo and Joey Words
Challenge No. 225: Kangaroo words are those words which contain the other words within themselves.
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.