Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Top 2 Runner-ups Without Win
Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 4 FIFA WC Champions
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.
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.
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.