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.
MAP
Applies a function to each element of one or more arrays in Excel.
Detect Common Groups by ID
Challenge No. 136: Find the common groups on the basis of common IDs.
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.
Replace letters with nearest vowels
Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.
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.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Calculate check digit using Damm algorithm
Challenge No. 338: Calculate check digit using Damm algorithm.
Solved using: Python in Excel.
Count of numbers where digits’ product equals value
Challenge No. 337: Find the Min, Max and Count of numbers having number of digits in column A whose product of digits is equal to column B.
Solved using: R.