Challenge No. 19: Lookup Subjects where at least 2 students scored 90 and above Dynamic array function allowed, but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Swap Alternate Rows
Challenge No. 81: Interchange the position of 1st row with 2nd, 3rd with 4th, 5th with 6th and so on.
Solved using: SQL.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Linear Interpolation!
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.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 2 Runner-ups Without Win
Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
Repeat Winners within 20 Years
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Consecutive FIFA Wins and Years
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
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.