LARGE Archives

Top Three Sales by Date

Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.

Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.

Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.

Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.

Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).

Challenge No. 165: List the First Ladies’ names which start with Top 3 most frequently occurring letters.
Solved using: Power Query.

Challenge No. 158: List the top 3 players in decreasing order of duration.
Solved using: Python in Excel.

Challenge No. 138: Find the top 5 highest occurring starting alphabets of words in US Presidents columns.
Solved using: Python in Excel.

Challenge No. 132: List the Top 3 players whose rank improved the most from 2021 to 2022.
Solved using: Python in Excel.

Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.