Challenge No. 196: Transpose the problem table into result table.
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.
Shared Item Billing Per Supplier
Challenge No. 195: Find the total amounts paid by all Stockists for the items purchased by them.
Solved using: R.
Parasitic Number Identification
Challenge No. 452: Parasitic number – is a positive natural number which, when multiplied by single digit n, results in movement of the last digit to its front.
Solved using: Excel VBA.
Max Consecutive Number Streak
Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.
Reverse Cumulative Row Sums
Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.
Rank Sales with Tie Handling
Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.
Group and Sum
Challenge No. 59: Group and Sum Shop Fruit Sales
e.
Solved using: R.
Identify Rotated String Matches
Challenge No. 449: List the String1 and String2 if they are rotated versions of each other.
Solved using: Python in Excel.