Challenge No. 49: Lookup the date when the staff total sales hit or exceeded the target
Current target is 800, but needs to be dynamic
e.
Solved using: Python.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
Transpose Team Problem Table
Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Custom Grouping! Part 12
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Find Isogram Calendar Dates
Challenge No. 265: An Isogram date is a two digits year date in which no digit occurs more than once.
Solved using: Power Query.
Find Previous Prime Digit Number
Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.