Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays 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.
End of Day Stock Record
Challenge No. 140: Work out the End of Day Stock.
Solved using: R.
Build Dictionary Excluding Vowels
Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
Validate IPv6 Address Format
Challenge No. 355: List all valid IPv6 addresses.
Solved using: Python in Excel.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
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.