Challenge No. 55: In the question table, transactions for different products are presented.
Solved using:Excel (FILTER, HSTACK, INDEX), Power Query (List.Distinct, Table.Group, Table.Pivot), Python, and R.
LAMBDA
Creates custom reusable functions in Excel.
Missing Values! Part 1
Challenge No. 54: The table presents the actual progress of three projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, EOMONTH), Power Query (List.Transform, Table.Group, Table.TransformColumnTypes), Python, and R.
Oeis Sequence
Challenge No. 53: The On-Line Encyclopedia of Integer Sequences presents several number sequences based on specific rules.
Solved using:Excel (FILTER, LAMBDA, LEFT), Power Query (List.Transform), Python, and R.
Find Missing Numbers!
Challenge No. 52: In the Question Table, numbers ranging from 1001 to 1018 are listed.
Solved using:DAX, Excel (COUNTIF, FILTER, IF), Power Query (List.Difference), Python, Python in Excel, R, SQL, and VBA.
Purchasing Together!
Challenge No. 51: In the Question Table, historical sales data are provided.
Solved using:Excel (BYROW, HSTACK, LAMBDA), Power Query (List.Contains, List.ContainsAll, List.Transform), Python, and R.
Assignment Problem (Part 2)!
Challenge No. 50: In the continuation of the previous challenge, we reach the question table as the normalized table, in the rest of the algorithm the below step should be done.
Solved using:Excel (AND, BYCOL, BYROW), Power Query (List.Transform, Table.Column), Python, and R.
Assignment Problem (Part 1)!
Challenge No. 49: Assignment Problem is a well-known problem for assigning tasks to different people by the minimum cost and we want to solve it with The Hungarian method within two challenges.
Solved using:Excel (BYCOL, BYROW, HSTACK), Power Query (List.Skip, List.Transform, Table.Column), Python, and R.
Table Transformation! Part 7
Challenge No. 48: The table below presents various combinations of heuristic algorithms used to solve a problem, each combination separated by a “+”.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (List.Distinct, List.Transform, Table.AddColumn), Python, and R.
Multiple Text Replacement!
Challenge No. 47: The “Question” table presents a list of product IDs collected from several warehouses.
Solved using:Excel (INDEX, LAMBDA, LET), Power Query (Text.Replace), Python, Python in Excel, and R.
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.