Challenge No. 119: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
DROP
Removes a specified number of rows or columns from an array in Excel.
Dso!
Challenge No. 118: Using the sales transactions from the provided table and the account balance as of 31/08/2024, calculate the Daily Sales Outstanding (DSO) for each customer.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Calculate financial year running totals
Challenge No. 39: Calculate Running Total for all individuals.
Solved using: Python in Excel.
Get Dates Before and After a New Order
Challenge No. 33: Get the dates BEFORE and AFTER a NEW ORDER
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Duplicate Values! Part 2
Challenge No. 113: Consider the IDs in the question table.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Compare Rows! Part 2
Challenge No. 111: In the historical sales table, extract the dates where the total sales value is greater than the total on the previous date
for example, in 2/1/2024 total sales were 14 and is greater than total sales on 1/1/2024 which is 11.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.Group, Table.SelectRows), Python, Python in Excel, and R.
Reconciliation!
Challenge No. 110: After reconciling the company’s bank transactions with the records in the financial department, discrepancies were found between 5 rows of bank transactions and 7 rows of financial records.
Solved using: Excel.
Sort Planets and Data
Challenge No. 113: Sort the planets first and then sort the data in respective rows
Note – I have updated the file but picture will continue to show wrong data.
Solved using: Python in Excel.
Find max finals gap for
Challenge No. 29: — This week is FIFA world cup challenges —
If a country has appeared more than once in finals, find the maximum gap in years for next – previous appearance for that country.
Solved using: SQL.
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.