Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
End of Day Stock Record
Challenge No. 140: Work out the End of Day Stock.
Solved using: R.
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.
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.
Assign Groups to Value Bins
Challenge No. 135: Generate the result table which is as per bin size.
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.
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.
Find nearest Palindrome numbers
Challenge No. 343: Palindrome number is that which is same even when read backwards.
Solved using: R.