Challenge No. 170: Given is a list of prime numbers.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Determine Cumulative Sum Based on Rules
Challenge No. 49: Generate the output table shown.
Solved using: SQL.
Merge! Part 2
Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Generate First Disarium List
Challenge No. 164: A Disarium number is that number where sum of each digit raised to the power of its position in the number is equal to number itself.
Solved using: Python in Excel.
Determine Result Table Based on Rules
Challenge No. 47: Count the process groups as given.
Solved using: Power Query.
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, Python in Excel, and R.
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.
Calculate financial year running totals
Challenge No. 39: Calculate Running Total for all individuals.
Solved using: Python in Excel.