Challenge No. 71: Extract all the emails from the text provided in the question table.
Solved using:Excel (FILTER, LEN, LET), Power Query (List.Transform, Text.Contains, Text.Split), Python, and R.
List.Transform
Applies a function to each element in a list in Power Query.
Coin Change Problem!
Challenge No. 70: Consider a set of coin denominations as: {1$, 2$, 5$, 10$}.
Solved using:Excel (FILTER, LAMBDA, LET), Power Query (List.Transform, Table.FromRows), Python, R, and VBA.
Character-Based Triangular
Challenge No. 68: Create a formula to receive a number n as input and generate a Triangular with a height equal to n using “*” characters.
Solved using:Excel (IF, LAMBDA, LET), Power Query (List.Repeat, List.Transform, Table.FromColumns), Python, R, and VBA.
Add Index Column! Part 1
Challenge No. 67: In the Question table, indexes along with their ranks in different references are provided.
Solved using:Excel (BYROW, FILTER, LAMBDA), Power Query (List.Skip, List.Transform, Table.SelectRows), Python, R, and VBA.
Table Transformation! Part 8
Challenge No. 65: In the question table, the total costs for different date ranges are provided.
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (List.Dates, List.Transform, Table.AddColumn), Python, R, and VBA.
Text Cleaning!
Challenge No. 64: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, with a default value of 1 for missing quantities.
Solved using:Excel (DROP, HSTACK, IFERROR), Power Query (List.Transform, Text.Split, Table.Split), Python, R, and VBA.
Merge Columns
Challenge No. 59: The power consumption of a house every 30 minutes on different dates is provided in the question table.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (List.Distinct, List.Skip, List.Split), Python, Python in Excel, and R.
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.
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.