Challenge No. 354: Merry Christmas to all the readers!!! Today’s challenge, undoubtedly, will be on Christmas.
Solved using: Power Query.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
Solved using: R.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
List Interprime Numbers
Challenge No. 352: List the Interprime Numbers.
Solved using: Python in Excel.
Reverse Words Between Indexes
Challenge No. 351: Reverse the words between two words whose both inclusive positions are given.
Solved using: Python in Excel.
Detect Common Groups by ID
Challenge No. 136: Find the common groups on the basis of common IDs.
Solved using: R.
Find Insolite Numbers
Challenge No. 350: List the Insolite Numbers – A number is Insolite if it is divisible by both
Sum of square of its digits AND
Product of square of its digits
Ex.
Solved using: Python in Excel.
Decimal to Roman Numerals
Challenge No. 349: For conversion from Decimal to Roman Number, value of characters to be used – M-1000, D-500, C-100, L-50, X-10, V-5 & I-1.
Solved using: R.
Assign Groups to Value Bins
Challenge No. 135: Generate the result table which is as per bin size.
Solved using: R.
Convert to Pig Latin Cipher
Challenge No. 348: Pig Latin Cipher – A new encrypted word is created with 3 components –
Component 1 – String having all alphabets from first vowel occurrence till end of the word
Component 2 – String having all alphabets before first vowel occurrence
Component 3 – String “ay”
Anything other than the English alphabet will be left as it is.
Solved using: R.