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.
By Topic
Challenges categorized by topic.
Characters Repetition!
Challenge No. 105: In the question table, where some passwords are provided, extract the 6 most commonly used characters across all the passwords and count their repetitions.
Solved using:Excel (CONCAT, FILTER, GROUPBY), Google Sheets, Power Query (List.Combine, List.Distinct, List.Transform), Python, Python in Excel, and R.
Latest Date Shop Data
Challenge No. 106: Get the data for all shops corresponding to latest date as shown in the result table.
Solved using: Python in Excel.
Weekday Count of Christmas
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Simuilation!
Challenge No. 104: Monte Carlo simulation is a technique used to predict the outcome of decisions by simulating a process multiple times.
Solved using:Excel, Power Query, Python, Python in Excel, and R.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Repeat Greek alphabets to match
Challenge No. 28: You will need to see which Greek alphabet appears maximum no.
Solved using: Power Query.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Pivoting Data
Challenge No. 22: Pivot the Customer’s table
Create a Total for each Month
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.