Challenge No. 330: Extract all the words which are greater than average length of the words in that sentence.
Solved using: R.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Find the first 50 Iccanobif numbers
Challenge No. 329: Find the first 50 Iccanobif numbers.
Solved using: Python.
Column Splitting! Part 5
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Find the next 3 Friday the 13th dates
Challenge No. 310: Find the next 3 Friday the 13th dates for dates given in column A.
Solved using: Python in Excel.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Hierarchical Structure!
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
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.