Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.
MID
Extracts a substring from a text string at a given position in Excel.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Absolute Alphabet Frequency Difference
Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.
Expand Alphabet Letter Gaps
Challenge No. 568: Fill in the missing letters between two letters in the given words.
Solved using: Python.
Reversed Even Perfect Squares
Challenge No. 565: Find first 50 numbers where both the number and its reversed number are
– Even
– Perfect squares
Ex.
Solved using: Python in Excel.
Palindrome One-Child Numbers
Challenge No. 562: One Child Palindromes – Find all unique substrings of a number excluding 0 and if one and only one substring is divisible by the length of the number, then this is called One Child number.
Solved using: Python.
Find Vowels Between Consonants
Challenge No. 560: Locate the vowels which are between two consonants.
Solved using: Python.
Find Watson-Crick Palindromes
Challenge No. 551: Watson-Crick (WK) Palindromes – A DNA string is a Watson-Crick (WK) Palindrome when the complement of its reverse is equal to itself.
Solved using: Python in Excel.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.