Challenge No. 178: Find the prime Factors of numbers in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, Python in Excel, R, and VBA.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Find Palindromic Numbers via 196
Challenge No. 296: 196-Algorithm – Take any positive integer of two digits or more, reverse the digits, and add to the original number.
Solved using: Python in Excel.
Generate Remaining Count Sentences
Challenge No. 295: Generate the given text from cell A2 onwards as per value given in cell A1.
Solved using: Python in Excel.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Filter!
Challenge No. 174: In the question table, filter out rows where there is a greater value within the two days before or after the current row.
Solved using:Excel (AND, FILTER, IF), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Identify Missing Brackets
Challenge No. 289: There are 3 types of Parentheses (brackets) – ( ), { }, [ ].
Solved using: Python in Excel.
Transpose Team Problem Table
Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).
Fill Down using dynamic arrays.
Challenge No. 47: Add the opening stock to each recorded stock during the day
Note that this is not a running total but a stock adjustment
For example, the last recording on the 10th is 201, i.
Solved using: Python in Excel.
Maximize Buy-Sell Profit Days
Challenge No. 287: You will need to buy first and sell later.
Solved using: Python in Excel.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.