Challenge No. 454: Today’s challenge is contributed by Sunny Baggu
Extract the total numbers in the problem strings.
Solved using: Python in Excel.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Group and Sum
Challenge No. 59: Group and Sum Shop Fruit Sales
e.
Solved using: R.
Unstack Groups for Summation
Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
Solved using: Python in Excel.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
Quarterly Hike Compounding Table
Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.