Challenge No. 94: Extract the middle words in given data.
Solved using: SQL.
Generate the result table as
Challenge No. 26: Generate the result table as shown.
Solved using: Power Query.
Draw Descending Triangle
Challenge No. 93: Draw the triangle as per number given in A1.
Solved using: Python.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
Approximate Lookup
Challenge No. 21: Lookup correct grades per subject
Marks below lowest grade is a fail
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Power Query.
List Valid EAN-13 Numbers
Challenge No. 91: Provide a formula to list down all valid EAN-13 numbers.
Solved using: Python 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.
If in a group of
Challenge No. 25: If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
Solved using: Power Query.
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.