Challenge No. 23: Count Quarters with 3 Consecutive L.
Solved using: Python in Excel.
Companies with Positive Growth
Challenge No. 99: List the companies which have positive annual growth rate during all 3 period years and their Average Annual Growth Rate (AAGR) .
Solved using: Python.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Find Two Numbers with Sum
Challenge No. 98: From column A, find 2 numbers which when summed give the sum as in column C.
Solved using: Python.
Pair clubs so each team
Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
Count Unique Odd Digit Numbers
Challenge No. 97: Yesterday, I ended up posting a complex challenge.
Solved using: Python in Excel.
Calculate Turnaround Time
Challenge No. 96: Calculate the Turn Around Time (TAT) i.
Solved using: Python.
Pivoting Data
Challenge No. 22: Pivot the Customer’s table
Create a Total for each Month
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
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.