Challenge No. 586: List all animals and all parks.
Solved using: Python.
SCAN
Scans an array and applies a function cumulatively in Excel.
Number Groups for Letter A
Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.
Work out tiered running totals
Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.
Progressive Column Max Finder
Challenge No. 559: For all columns, find the max in a cell considering its range from 1st cell till that cell.
Solved using: Excel VBA.
Prepare the result table from
Challenge No. 252: Prepare the result table from problem table.
Solved using: Python.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.
Sum Sales By Month
Challenge No. 230: Summarize the table as shown by summing up Sales against each month.
Solved using: Python in Excel.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Insert Group Name
Challenge No. 66: Group the staff and insert the group name after the last count.
Solved using: Python.