Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
Custom Grouping
Challenges related to custom data grouping.
Extract last group of digits from string
Challenge No. 34: Extract the last group of numbers from a given string.
Solved using: Python in Excel.
Custom Grouping! Part 2
Challenge No. 46: The “Question” table provides a list of Product IDs.
Solved using:Excel (CHOOSECOLS, DROP, FILTER), Power Query (Table.Group, List.Transform, Text.End), Python, and R.
Custom Grouping! Part 1
Challenge No. 2: Group the rows from the top, which in each group the total cost be lower than 130$.
Solved using:Excel (HSTACK, IF, LAMBDA), and Power Query (Table.Group).