Challenge No. 50: If there is a discontinuity in dates for a Store, fill in the missing dates with details of previous records and also fill in the sequence of record numbers for a customer in that store.
Solved using: SQL.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Substring Repeat Detection
Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
Generate Unique Records Based on Rules
Challenge No. 45: Calculate Running Total for each dealer.
Solved using: SQL.
Extract Running Total By Group
Challenge No. 43: Generate result table as shown.
Solved using: Excel VBA.
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.
Find Date Range Alphabetically
Challenge No. 41: Similar kind of problem appeared in MS Techcommunity and this is a variation of that.
Solved using: Excel VBA.
Merge! Part 1
Challenge No. 114: In Question Table 1, the dates and product IDs are provided.
Solved using:Excel (FILTER, HSTACK, IFERROR), Google Sheets, Power Query (Text.Split, Table.AddColumn), Python, Python in Excel, R, and SQL.
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.
Get Last Order
Challenge No. 31: Get the last order for each Month
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
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.