Challenge No. 199: Extract part no.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
Group Per Month
Challenge No. 60: Group the customers per month.
Solved using: Python.
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.