Challenge No. 163: Extract the valid vehicle registration numbers from given data table T2.
Solved using: R.
MID
Extracts a substring from a text string at a given position in Excel.
Form Pyramid from Text String
Challenge No. 401: Prepare the triangle from column A strings.
Solved using: Python.
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.
List Super-Palindrome Numbers
Challenge No. 394: A palindrome number is that which is same even where read backwards.
Solved using: Python in Excel.
Encrypt with Autokey Cipher
Challenge No. 393: AUTOKEY CIPHER – Key is written beneath Plaintext and if key is shorter than Plaintext, then remaining slots beneath Plaintext are filled by letters from Plaintext starting from beginning.
Solved using: R.
Reorder Letters by Position Type
Challenge No. 392: Reading from backwards, collect all letters occurring at even positions followed by all letters occurring at odd positions.
Solved using: Python in Excel.
Form Shortest Palindromic Prefix
Challenge No. 391: Find the smallest Palindromes (in length) which can be formed by adding English alphabets before string.
Solved using: Python in Excel.
Slice Numbers with Greater Rules
Challenge No. 384: Take position 1 in given number as first slice (I am following index 1 notation of Excel not index 0) and cut the slice starting from position 2 in such a way that the slice is > previous slice.
Solved using: Python in Excel.