Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
MID
Extracts a substring from a text string at a given position in Excel.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Replace with Past Vowels
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
List Valid EAN-13 Numbers
Challenge No. 91: Provide a formula to list down all valid EAN-13 numbers.
Solved using: Python in Excel.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
List 2nd and 4th Saturdays
Challenge No. 56: Provide a formula to generate the list of 2nd and 4th Saturdays for a given quarter and year in A1.
Solved using: Power Query.
Check Word Anagram Pair
Challenge No. 50: An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.
Solved using: Power Query.
Digits in Increasing Sequence
Challenge No. 49: Provide a formula to list those numbers in A2:A10 where every succeeding digit is >= previous digit.
Solved using: Python in Excel.
Sort Cities on Reversed Prefix
Challenge No. 48: Sort (case insensitive) the cities on the basis of first word of the city names and sorting should be done on the basis of first word read backward i.
Solved using: Power Query (Table.AddColumn, Table.Sort).