Challenge No. 503: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Calculate the sum, average, maximum value, minimum value, count, and payment amount for products purchased by each customer.
Solved using: Python in Excel.
DROP
Removes a specified number of rows or columns from an array in Excel.
Find Row/Col Consecutive Numbers
Challenge No. 501: In the given grid, find the numbers which are consecutive either column wise or row wise (not diagonal wise).
Solved using: Python.
Extract Entries from Running Total
Challenge No. 500: Get the individual entries from the running total which is across the row and continues to the next rows.
Solved using: Python.
Normalize Staff Entries
Challenge No. 219: Normalise the table as shown.
Solved using: Python.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
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.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.