Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
ROWS
Returns the number of rows in an array or range in Excel.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Validate Chessboard Pattern
Challenge No. 525: Determine whether a given chess board is valid or not.
Solved using: Python.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Subject Scores Transposition
Challenge No. 223: Transpose the problem table into result table.
Solved using: Python.
Aggregate Customer Purchase Stats
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.
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.
Triangular Record Grouping
Challenge No. 477: Align the data as shown which is 1 record, then 2 records, then 3 records and so on.
Solved using: Python in Excel.
Compile Role Based Totals
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.