Challenge No. 367: Capture the word starting at given index.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Alternate Letters and Numbers
Challenge No. 366: Arrange the given characters in such a fashion that alphabets occupy all odd positions and numbers occupy even position in the order in which they appear.
Solved using: Python.
One Digit Equals Other Sum
Challenge No. 365: List the numbers where one digit is equal to sum of other digits.
Solved using: R.
Sequential Digit Difference Match
Challenge No. 364: List the numbers where absolute difference between two succeeding digits is 1, 2, 3, 4.
Solved using: Python.
Increment Number at Word End
Challenge No. 363: If any word contains numbers at the end of the word, add 1 to that number.
Solved using: Python in Excel.
Uppercase Letters Around Numbers
Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.
Extract Longest Alphanumeric Segment
Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
Sum of Unique Consecutive Numbers
Challenge No. 359: Express the numbers as sum of 2 or more unique consecutive numbers.
Solved using: R.
Stack Matrix Diagonals Horizontally
Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.
Build Dictionary Excluding Vowels
Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.