Challenge No. 106: Rank the countries based on Olympic medals, starting with the number of gold medals.
Solved using:Excel, Power Query, Python, and R.
Indexing & Ranking
Creating indexed/ranked lists in datasets.
Random Selection! Part 2
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
Best and Worst Rank Changes
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.
Top Products!
Challenge No. 96: In the Question table, daily sales information is provided.
Solved using:Excel, Google Sheets, Power Query, Python, R, and SQL.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.
Add Index Column! Part 1
Challenge No. 67: In the Question table, indexes along with their ranks in different references are provided.
Solved using:Excel (BYROW, FILTER, LAMBDA), Power Query (List.Skip, List.Transform, Table.SelectRows), Python, R, and VBA.