Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Top Products!
Challenge No. 96: In the Question table, daily sales information is provided.
Solved using:Excel, Google Sheets, Power Query, Python, R, and SQL.
Top Students Subject Order
Challenge No. 19: Generate Top 3 students in all subjects.
Solved using: Power Query.
Count Prime Numbers in Range
Challenge No. 58: Count prime numbers between given Lower and Upper Limits.
Solved using: Python in Excel.
Consecutive Dates Task Grouping
Challenge No. 17: (Excel formulas also welcome)
Generate the output table.
Solved using: Power Query.
Reverse Lookup
Challenge No. 9: Reverse Lookup of all the scheduled jobs, Dates and Time
Strictly Legacy Array Functions or PowerQuery.
Solved using: Python.
Missing Values! Part 3
Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
Dynamic Table Generation Result
Challenge No. 16: (Excel formulas also welcome)
Generate the Result table shown.
Solved using: Power Query (List.Distinct, Table.Pivot, Table.PromoteHeaders).
Fill Missing Sequences Per ID
Challenge No. 12: (Excel formulas also welcome)
If there is a sequence missing for a given ID, fill in the missing sequence and repeat the row above for all other columns.
Solved using: Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group).
Flexible Result Table Creation
Challenge No. 11: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (List.Distinct, Table.AddColumn, Table.Pivot).