Challenge No. 93: Draw the triangle as per number given in A1.
Solved using: Python.
By Difficulty
Challenges categorized by difficulty level.
Generate the result table as
Challenge No. 26: Generate the result table as shown.
Solved using: Power Query.
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.
Numbers with Odd Frequencies
Challenge No. 89: List the numbers which occur odd number of times.
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.
Generate Tabula Recta Grid
Challenge No. 88: Generate the given grid.
Solved using: Python.
Analyse Data Using Financial Year
Challenge No. 20: Analyse the sales data by Financial Year and Financial Quaters
Assume the Financial year starts in April
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.