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.
SEQUENCE
Generates a sequence of numbers in an array 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.
Generate Axis for Four Quadrants
Challenge No. 389: Generate X and Y axes of all 4 quadrants for value given in A1.
Solved using: R.
Kamasutra Cipher with Digits
Challenge No. 388: Kamasutra Cipher 2 – Generate 13 random pairs from English alphabets and 5 random pairs from 0-9 digits and use that to encrypt the plain text.
Solved using: R.
Last Weekday of Each Month
Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.
Render Provided Grid Design
Challenge No. 385: Generate the given grid.
Solved using: R.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Generate Kamasutra Cipher Encryption
Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.