Challenge No. 568: Fill in the missing letters between two letters in the given words.
Solved using: Python.
MAP
Applies a function to each element of one or more arrays 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.
First and Last Number Sum
Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
Five-Weekend Month Finder
Challenge No. 541: List the months and years having 5 Fridays, 5 Saturdays and 5 Sundays in a month for the years 2000 to 2999.
Solved using: Python in Excel.
Compute Average Supplier Price
Challenge No. 539: Table1 gives the Items, Suppliers and per unit rate for different band of quantities.
Solved using: Python in Excel.