Challenge No. 13: Provide a formula to generate the list of animals who are common in all 3 columns.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition 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.
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.
Determining Missing Fields
Challenge No. 74: Customer information including Name, Family, Phone, and Website is provided in the question table.
Solved using:Excel (ARRAYTOTEXT, FILTER, HSTACK), Power Query (List.Difference, List.Distinct, Text.Combine), Python, and R.
Character-Based Triangular
Challenge No. 68: Create a formula to receive a number n as input and generate a Triangular with a height equal to n using “*” characters.
Solved using:Excel (IF, LAMBDA, LET), Power Query (List.Repeat, List.Transform, Table.FromColumns), Python, R, and VBA.
Merged Cells!
Challenge No. 66: Convert the Question table with the merge headers into the result table.
Solved using:Excel (DROP, HSTACK, IF), Power Query (List.Distinct, List.PositionOf, Table.Pivot), Python, R, and VBA.
Missing Values! Part 2
Challenge No. 62: The question table presents the actual progress of 3 projects at the end of each month, but some values are missing.
Solved using:Excel (DATE, DROP, IF), Power Query (Date.Month), Python, and R.
Sales Per Customer
Challenge No. 61: In Question Table 1, sales transactions are provided.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (Table.Group, Table.Sort), Python, R, and VBA.
Match Payments!
Challenge No. 60: The customer receipt costs and their payments are provided in Question Tables 1 and 2.
Solved using:Excel, Power Query, and R.
Merge Columns
Challenge No. 59: The power consumption of a house every 30 minutes on different dates is provided in the question table.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Power Query (List.Distinct, List.Skip, List.Split), Python, Python in Excel, and R.