Challenge No. 19: Generate Top 3 students in all subjects.
Solved using: Power Query.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Custom Splitter (Part 2)!
Challenge No. 73: In the Question table, sales information including Date, Product Names, and quantity are provided without any separators like CH 63 with the difference that on each date, more than one transaction might provided.
Solved using:Excel (CHAR, DROP, HSTACK), Power Query (List.Skip, List.Transform, Table.AddColumn), Python, and R.
Fibonacci Sequence!
Challenge No. 72: Generate the first 18 terms of Fibonacci sequence as result table.
Solved using:Excel, Power Query, Python, R, and VBA.
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.
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.
Sales Per Customer
Challenge No. 61: In Question Table 1, sales transactions are provided.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (Table.Group, Table.Sort), Python, R, and VBA.
Match Payments!
Challenge No. 60: The customer receipt costs and their payments are provided in Question Tables 1 and 2.
Solved using:Excel, Power Query, 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.