Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
⭐️⭐️ Easy
Slightly challenging problems for learners.
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.
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.
Detect Repeated Digits in Numbers
Challenge No. 64: List the numbers which have got any digits repeated.
Solved using: Python in Excel.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.
Generate Sum with Conditions
Challenge No. 60: There are two tables.
Solved using: Power Query.
Clean and Sum a Text String
Challenge No. 13: Calculate the remaining visits
Strictly Legacy array function or PowerQuery.
Solved using: Python in Excel.
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.