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.
LAMBDA
Creates custom reusable functions in Excel.
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.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
Daily Stock Closing Value
Challenge No. 134: Yesterday’s challenge was a tough one.
Solved using: Python in Excel.
Replace letters with nearest vowels
Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.
Sum digits along diagonals of grid
Challenge No. 345: Find the sum of digits of both the diagonals for the grids given.
Solved using: R.
Meter Reading Consumption Split
Challenge No. 133: Find out the electricity consumption for all 3 meters for given dates.
Solved using: R.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
Find nearest Palindrome numbers
Challenge No. 343: Palindrome number is that which is same even when read backwards.
Solved using: R.