Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
SORT
Sorts an array in ascending or descending order in Excel.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
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.
Top 5 Goal Scoring Teams
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
Teams Repeated in Finals
Challenge No. 73: — This week will be FIFA World Cup week.
Solved using: SQL.
Top Three Frequent Alphabets
Challenge No. 63: Provide a formula to list the top 3 highest occurring English alphabets in A2:A47 along with their frequencies.
Solved using: Power Query.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.
Find Matches with Same Goals
Challenge No. 61: List the matches where total goals scored are same.
Solved using: Excel VBA.