Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
REDUCE
Reduces an array to a single value using an accumulator function in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Multiply Fibonacci and Lucas Numbers
Challenge No. 376: Lucas Numbers – A term is sum of immediate previous two terms.
Solved using: Python.
Draw Inverted Triangle Shape
Challenge No. 372: Draw inverted right angled triangles as shown for an r value.
Solved using: Python.
Uppercase Letters Around Numbers
Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.
Find Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.
Calculate check digit using Damm algorithm
Challenge No. 338: Calculate check digit using Damm algorithm.
Solved using: Python in Excel.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.