Challenge No. 91: Provide a formula to list down all valid EAN-13 numbers.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Get 4th Breakdown if >
Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
Solved using: Python.
Generate Tabula Recta Grid
Challenge No. 88: Generate the given grid.
Solved using: Python.
Region-Year with Max Growth
Challenge No. 87: Find the Region and Year where and when the growth was the highest.
Solved using: DAX.
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.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.