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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
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.
List Tautonym words
Challenge No. 294: List Tautonym words.
Solved using: Python in Excel.
Rank by Best of 3 Subjects
Challenge No. 106: Generate the result table from problem table.
Solved using: Power Query.
Words in Alphabetical Order
Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.
Custom Grouping! Part 16
Challenge No. 176: Group every five rows of the question table and then provide some of quantity for each group.
Solved using:Excel (GROUPBY, HSTACK, LAMBDA), Google Sheets, Power Query (Table.Group, List.Transform, Table.AddIndexColumn), Python, Python in Excel, and R.
Add Time to Duration Format
Challenge No. 105: Add Text Time and Add columns together and present result in duration format i.
Solved using: Excel VBA.