Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
Evaluate Reverse Polish Notation
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
Prime Factors!
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.
Find Entry-Exit Exceptions
Challenge No. 109: For every entry, there has to be an exit which should come after entry.
Solved using: Excel VBA.
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.
Lookup Date When Target was Hit
Challenge No. 49: Lookup the date when the staff total sales hit or exceeded the target
Current target is 800, but needs to be dynamic
e.
Solved using: Python.
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.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
List Tautonym words
Challenge No. 294: List Tautonym words.
Solved using: Python in Excel.