Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
By Topic
Challenges categorized by topic.
Consecutive Wins Within Span
Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
Sum Visible Rows Using a Criteria
Challenge No. 16: Sum the total sales of the visible cells
NB: Include all “MILK” Product
Dynamic array function allowed but
Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
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.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
Random Selection! Part 1
Challenge No. 93: Randomly select a staff member from each department.
Solved using:Excel (FILTER, HSTACK, INDEX), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.