Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Reverse, Cipher and Shift Text
Challenge No. 407: Mirror Cipher with Caesar’s Shift – Reverse the words and then reverse the alphabets within the words.
Solved using: Python.
List Prime-Surrounded Sandwich Numbers
Challenge No. 405: Sandwich numbers – A number is said to be a Sandwich number if the number prior to it and the number after it, both are primes.
Solved using: Excel VBA.
Encrypt Using Vigenere Cipher
Challenge No. 402: Vignere Cipher – Write the plain text (p) and keyword (k) beneath that.
Solved using: Python in Excel.
Form Pyramid from Text String
Challenge No. 401: Prepare the triangle from column A strings.
Solved using: Python.
Extract Alphabet Number Pairs
Challenge No. 162: Extract alphabet and two digit numbers strings if alphabet and two digit numbers are separated by a special character.
Solved using: R.
Count Unique Letters in String
Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
Solved using: Python.
Encrypt Words with Tri Numeral Cipher
Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.
Count Inversions in Number Sequence
Challenge No. 396: Let’s say i and j are positions and e(i) and e(j) are elements from the string at that position.
Solved using: Python.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.