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.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Author Sale Difference
Challenge No. 133: List the authors who have written more than one book and have the highest difference between Max of Sold and Min of Sold.
Solved using: Python in Excel.
Top Rank Improvements
Challenge No. 132: List the Top 3 players whose rank improved the most from 2021 to 2022.
Solved using: Python in Excel.
Extract Complete Months
Challenge No. 32: Calculate the number of complete Months per Year per Project
For example, Proj A starts in 2022 (for 10 months), 2023(12 months), Ends 2024(6 months)
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Add Spaces Between Types
Challenge No. 128: Insert a space whenever there is a transition from alphabet to number OR number to alphabet in the strings.
Solved using: SQL.
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.
Add Large Text Numbers
Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.