Challenge No. 679: For production runs, number of items (say N) to be selected in one go is given in every column.
Solved using: Python.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Quarterly Payment Grouping
Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Track Quality Test Rounds
Challenge No. 664: After 3 rounds of quality testing, list the remaining batches from Round0 after each Round.
Solved using: Python in Excel.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Identify Yearly Repeat Customers
Challenge No. 636: Find the unique repeat customers in a year.
Solved using: Python.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.
