Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
UNIQUE
Returns unique values from a range or array in Excel.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.
Duplicate Values! Part 1
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Align Names by Cities
Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
Subjects Taught Exclusively
Challenge No. 85: Column A lists down subjects taught by Female and Male Teachers.
Solved using: SQL.
Flag Columns with Special Keys
Challenge No. 24: Generate the result table.
Solved using: Power Query (List.Distinct).
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Random Selection! Part 2
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.
Frequent Starting Team Letters
Challenge No. 76: — This week will be FIFA World Cup week.
Solved using: Power Query.