Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
By Topic
Challenges categorized by topic.
Fill Missing Sequences Per ID
Challenge No. 12: (Excel formulas also welcome)
If there is a sequence missing for a given ID, fill in the missing sequence and repeat the row above for all other columns.
Solved using: Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group).
Sum Every Nth Occurrence based on a Criteria Challenge
Challenge No. 4: Sum Every Nth Occurrence per payment if the project meets the criteria
Strictly Legacy Array Functions or PowerQuery
Note:
Every payment has 5 occurrences.
Solved using: Power Query.
Return the Most Recent Day of Week
Challenge No. 5: Return a Date of the most recent/next day of the week starting from Today
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Subtotal Calculation!
Challenge No. 88: In the question table, sales info is provided.
Solved using:Excel, Power Query, Python, R, and SQL.
Counting Days of the Week Between Dates
Challenge No. 2: Count the number of days between two dates
Strictly Legacy Array Functions or PowerQuery
Hazem Hassan.
Solved using: Power Query.
Creating the Stem & Leaf Report
Challenge No. 1: Create a Stem & Leaf Plot
Strictly Legacy Array Functions or PowerQuery
NB:
A Stem and Leaf Plot is a special table where each data value is split into a “stem” (the first digit or digits) and a “leaf” (usually the last digit).
Solved using: Excel VBA.
Price List!
Challenge No. 87: The question tables provide product price lists on various dates and transaction records.
Solved using:Excel (FILTER, LAMBDA, LOOKUP), Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
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.
List Local Temperature Peaks
Challenge No. 32: Provide a formula to list the dates when temperature has been greater than previous day and next day both.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).