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.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Transpose First/Last Names
Challenge No. 131: Transpose the problem table into Result table.
Solved using: R.
Find unique number pairs
Challenge No. 336: Find the unique pair of numbers.
Solved using: Python in Excel.
Custom Grouping! Part 19
Challenge No. 197: Group the rows sequentially from the top, ensuring that each group contains exactly one missing date.
Solved using:Excel (IF, LET, SCAN), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn), Python, Python in Excel, and R.
List all Amicable numbers
Challenge No. 334: List the Amicable numbers.
Solved using: Python in Excel.
Extract string before any letter repeats
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
List numbers expressible as sum of two cubes
Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.
Missing Characters!
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Top 3 marks with names and subjects
Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.