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.
LET
Assigns names to values or calculations to simplify formulas 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.
Replace Masked Characters
Challenge No. 131: The strings given in column A have some alphabets which are masked i.
Solved using: Excel VBA.
Custom Rank! Part 2
Challenge No. 112: In the question table, rank the products based on the difference between sales in 2023 and 2022, in descending order.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (Table.AddIndexColumn, Table.Sort), Python, Python in Excel, and R.
Capitalize First and Last
Challenge No. 130: Convert the first and last letters of each word to upper case.
Solved using: Power Query (List.Transform).
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
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.
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.