Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
SCAN
Scans an array and applies a function cumulatively in Excel.
Distribute Consecutive Numbers
Challenge No. 674: This challenge has been contributed by Mehmet Çiçek
List consecutive numbers into different columns.
Solved using: Python in Excel.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Names With Total Costs
Challenge No. 644: List All names and total cost against each name.
Solved using: R.
Sum Between Plus Groups
Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Generate Sum of Digits Sequence
Challenge No. 613: Sum of Digits Sequence – It starts with 1 and every succeeding term is sum of all digits appearing previously.
Solved using: Excel VBA.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Repeat Vowels by Position
Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.
