Challenge No. 80: The Convex Hull Algorithm leads to the smallest convex area (Polygon) that includes all the points in the dataset.
Solved using:Excel, Python, and R.
List Numbers Appearing Repeatedly
Challenge No. 6: Provide a formula to list numbers which appear more than once in Range A2:A20 and have both B and C in B2:B20.
Solved using: Python in Excel.
Separate Alphabets and Numbers
Challenge No. 2: (Excel formulas also welcome)
Extract all alphabets in one column and numbers in another column.
Solved using: Python in Excel.
Find Max Points by Rounds
Challenge No. 5: Provide a formula to know the name of the persons who have the highest Points on the basis of Round1+Round2+Round3.
Solved using: Python in Excel.
Extract All-Caps Words
Challenge No. 4: Provide a formula to Extract the Words which are all capitals (upper case).
Solved using: Python in Excel.
Remove Blank Columns!
Challenge No. 79: In the question table, some columns are entirely blank.
Solved using:Excel (BYCOL, FILTER), Power Query (List.Transform, Table.Column, Table.ColumnNames), Python, Python in Excel, R, and VBA.
Extract Numbers and Sum Digits
Challenge No. 1: Extract the numeric digits from the given strings in a column and sum the digits for those extracted strings in another column.
Solved using: Power Query (Table.AddColumn).
Extract From Text! Part 2
Challenge No. 78: Extract all the Dates from the text provided in the question table in different formats.
Solved using:Excel, Power Query, Python, R, and VBA.
Character-Based Rhombus
Challenge No. 77: Create a formula to receive a number n as input and generate a rhombus with a diameter equal to n using “*” characters.
Solved using:Excel (DROP, IF, LAMBDA), Power Query (List.Transform), Python, R, and VBA.
Reverse Stepped Tax!
Challenge No. 76: In challenge 58, we aimed to find an efficient way to calculate the stepped tax based on the tax rates presented in the question table.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Power Query (Table.AddColumn), Python, Python in Excel, and R.