Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Table.SelectRows
Filters rows in a table based on a condition in Power Query.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
First and Last Duplicates
Challenge No. 143: List those rows for employees where first and last duplicate values occur for a value.
Solved using: Python in Excel.
Find unique number pairs
Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Table Transformation! Part 24
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Transform Source to Result Table
Challenge No. 121: Transform the problem table into result table.
Solved using: Excel VBA.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Filter!
Challenge No. 174: In the question table, filter out rows where there is a greater value within the two days before or after the current row.
Solved using:Excel (AND, FILTER, IF), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Transpose Team Problem Table
Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).