Challenge No. 101: Divide the numbers given in column A by 7 and round it up.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
Count Rows with All Values
Challenge No. 95: Find the number of rows in the grid B2:M10 where O2:O4 values appear at least once.
Solved using: Python.
Compare Rows! Part 1
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Draw Descending Triangle
Challenge No. 93: Draw the triangle as per number given in A1.
Solved using: Python.
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.
Generate Tabula Recta Grid
Challenge No. 88: Generate the given grid.
Solved using: Python.
Align Names by Cities
Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Lookup and Concat Data Using a Criteria
Challenge No. 19: Lookup Subjects where at least 2 students scored 90 and above Dynamic array function allowed, but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.