Challenge No. 179: Generate the result table from problem table.
Solved using: R.
DROP
Removes a specified number of rows or columns from an array in Excel.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Validate Point Connectivity Rule
Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
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.
Numbers With Larger Successors
Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.