Challenge No. 462: Fill in the blanks with max from the immediate surrounding cells.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Custom String Sorting
Challenge No. 461: Sort the given strings as given in the answer.
Solved using: Python.
Insert Dashes After N Characters
Challenge No. 460: Insert the dashes after every N characters.
Solved using: Excel VBA.
Monthly Running Max Total
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.
Longest Uppercase Substring
Challenge No. 458: Extract the substrings which have longest sequence of capital (uppercase) letters in given words.
Solved using: Python.
Extract Numbers in Parentheses
Challenge No. 457: Extract the numbers if they are within parenthesises.
Solved using: Python in Excel.
Extract Special Characters Only
Challenge No. 456: Extract special characters from given strings.
Solved using: R.
Identify Anti-Perfect Numbers
Challenge No. 455: Anti perfect number is that number where number is equal to sum of reverse of its perfect divisors’ digits.
Solved using: Python in Excel.
Count Numbers from Ranges
Challenge No. 454: Today’s challenge is contributed by Sunny Baggu
Extract the total numbers in the problem strings.
Solved using: Python in Excel.
Common Entries and Count
Challenge No. 453: Today’s challenge is contributed by Mehmet Çiçek
Find the common entries in List1 and List2 and common count.
Solved using: Excel VBA.