Challenge No. 96: In the Question table, daily sales information is provided.
Solved using:Excel, Google Sheets, Power Query, Python, R, and SQL.
Repeat Winners within 20 Years
Challenge No. 70: — This week will be FIFA World Cup week.
Solved using: SQL.
Mismatch Fields Per Employee
Challenge No. 20: There are two rows per Emp ID which are from two different sources.
Solved using: Power Query (Table.AddColumn).
Consecutive FIFA Wins and Years
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
Advanced Lookup Data Separated by a Carriage Return
Challenge No. 15: Extract the least performed subject and marks
Dynamic array function allowed
but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Find Duplicate Surnames
Challenge No. 67: List down the first ladies’ names where surnames (i.
Solved using: Power Query.
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.
Top Students Subject Order
Challenge No. 19: Generate Top 3 students in all subjects.
Solved using: Power Query.
Find Consecutive Birds
Challenge No. 66: List down the birds which appear consecutively at least 2 times.
Solved using: Python in Excel.