Challenge No. 123: Group the sales values in 10-day intervals, starting from January 1, 2024.
Solved using:Excel (BYROW, DAY, GROUPBY), Google Sheets, Power Query (Table.Group, List.Transform, Table.Group), Python, Python in Excel, and R.
Custom Grouping
Challenges related to custom data grouping.
Determine Result Table Based on Rules
Challenge No. 47: Count the process groups as given.
Solved using: Power Query.
Custom Grouping! Part 4
Challenge No. 119: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
Grouping Data
Challenge No. 38: Sort Cookies into 2 groups: with Duplicate Price & with Unique prices Dynamic array function allowed but
Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Custom Grouping! Part 3
Challenge No. 109: Dates were grouped by sales trends, with each group extending until a drop in sales occurred.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Form quarterfinal pairs by FIFA
Challenge No. 32: — This is the last problem in the series of FIFA world cup challenges.
Solved using: SQL.
Extract Top Number Groups
Challenge No. 114: Extract the group of numbers from A2:A11 and list the top 3 unique maximum and minimum numbers.
Solved using: SQL.
Find Non-Common Words
Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
Solved using: SQL.
If in a group of
Challenge No. 25: If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
Solved using: Power Query.
Pair Semi-Final Cricket Teams
Challenge No. 62: This challenge is inspired from ongoing T20 Cricket World cup.
Solved using: Power Query.