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.
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.
Insert blank rows based on
Challenge No. 35: Insert the number of blank rows after the records as per Number column.
Solved using: Python.