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.
SEQUENCE
Generates a sequence of numbers in an array 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.
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.
Find Perfect Square Dates
Challenge No. 292: List all dates in 21st century which are perfect square dates.
Solved using: Python.
Reverse data given in rows
Challenge No. 291: Reverse data given in rows.
Solved using: Python in Excel.
Custom Grouping! Part 15
Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), Python, Python in Excel, and R.
Pair and Sort People
Challenge No. 288: Make groups of 2 persons each in sequence and sort them.
Solved using: Python in Excel.
List all Right Truncatable Primes
Challenge No. 286: List all Right Truncatable Primes.
Solved using: Python in Excel.