Challenge No. 403: Generate the Sum of Value and % of Value for year brackets of 5 years each.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Min and Max Dates by Group
Challenge No. 398: Generate the min and max dates for different year and month combinations.
Solved using: Python in Excel.
Distance Matrix Between Cities
Challenge No. 160: x, y coordinates are given for different cities.
Solved using: Python in Excel.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.
Transpose Problem Table Format
Challenge No. 158: Transpose the Problem table into Result table.
Solved using: R.
Assign Teachers to Students
Challenge No. 156: Last Sunday’s challenge was deemed to be super-difficult.
Solved using: Python.
Render Provided Grid Design
Challenge No. 385: Generate the given grid.
Solved using: R.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Pilot Flight Rest Hours
Challenge No. 153: This time this problem will appear on both Sat and Sun with variations.
Solved using: Python in Excel.
Fruit Pair Frequency Grid
Challenge No. 148: Generate the grid shown where count need to be populated at intersections of rows and columns.
Solved using: Python.