Applies a function to each element of one or more arrays in Excel.
Challenge No. 26: The provided question table contains information regarding the amount of time individuals spend in meetings with each other, and we want to generate a result table that displays the percentage of time each person (G3:G7) spends with others (H2:L2), ensuring that the sum of each row equals 100%.
Solved using:Excel (HSTACK, INDEX, LAMBDA), and Power Query (Table.AddColumn).
Challenge No. 21: In the question table, a list of machinery codes alongside the potential product codes each machine can produce is presented.
Solved using:Excel (FILTER, HSTACK, LAMBDA), Power Query (Text.Combine, Table.Group, Table.Sort), and R.
Challenge No. 19: Solve the left side Sudoku table and replace X by a number based on the below rule:
Use the numbers 1 through 6 instead of X.
Solved using:Excel, Power Query, and VBA.
Challenge No. 16: Change the format of the data from the question table to that of the result table.
Solved using:Excel, Power Query, and R.
Challenge No. 14: Create a list of products sold in all the months throughout the year.
Solved using:Excel (COUNT, FILTER, LAMBDA), Power Query (Date.Month, List.Distinct, List.Transform), and R.
Challenge No. 11: Extract all item codes that are repeated at least in 3 out of 4 lists presented in the question table.
Solved using:Excel (BYCOL, FILTER, LAMBDA), Power Query (List.Combine, List.Distinct, List.Transform), and R.
Challenge No. 10: The question table shows inventory levels for materials required to produce products, with specific combinations (1 A, 2 B, 3 C per product).
Solved using:Excel (HSTACK, LAMBDA, LET), Power Query (Table.AddColumn, Table.Group), and R.
Challenge No. 9: repetition of a specific pattern!
Identify the longest continuous repetition of the
pattern “+ – -” and “+ -” in the question table for each product.
Solved using:Excel, Power Query, and R.
