Challenge No. 85: Column A lists down subjects taught by Female and Male Teachers.
Solved using: SQL.
TEXTJOIN
Concatenates text from multiple cells using a delimiter in Excel.
Lookup and Concat Data Using a Criteria
Challenge No. 19: Lookup Subjects where at least 2 students scored 90 and above Dynamic array function allowed, but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.
Top Scorers by Subject
Challenge No. 20: List the distinct Subjects and Students who have scored the highest marks in those subjects along with Marks scored by them.
Solved using: Python in Excel.
List Longest Words in Sentence
Challenge No. 19: Provide a formula to list longest words in sentences given in A2:A10.
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.
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.
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.