Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
Solved using: Python in Excel.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Task Assignment Load Balancing
Challenge No. 465: There are 4 persons who can be a candidate to do a task.
Solved using: Python in Excel.
Unstack Groups for Summation
Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Find Birds in Grid Rows
Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Square Digits Until Single Number
Challenge No. 412: Square the individual digits of a number and sum them.
Solved using: Python in Excel.