Challenge No. 8: (Excel formulas also welcome)
Clean the data and generate the result table as shown.
Solved using: Power Query (Table.AddColumn, Table.TransformColumns).
Missing Triangle Side Integer
Challenge No. 21: A right angle triangle is that for whom following property is satisfied.
Solved using: Python in Excel.
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.
Count Unique Subjects Per Row
Challenge No. 6: (Excel formulas also welcome)
Count the no.
Solved using: Power Query (Table.TransformColumns).
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.
Custom Splitter (Part 3)!
Challenge No. 83: In the Question table, sales information, including dates, product names, and quantities, is provided in a single cell.
Solved using:Excel (IFERROR, LET, ROWS), Power Query (List.Transform, Text.Split, Table.FromRows), Python, Python in Excel, R, and SQL.
Triangle Side Validation
Challenge No. 18: Provide a formula to list all Triangles from A2:A10.
Solved using: Python in Excel.
Words Around SELECT
Challenge No. 16: Provide a formula to list all bird names which appear immediately before and after SELECT in range A2:A20.
Solved using: Python in Excel.
Text After Last Number
Challenge No. 15: Find the text of string following the last numeric digit in a string.
Solved using: Python in Excel.
Diagonal Sum Difference
Challenge No. 14: Provide a formula to find the difference between sum of right diagonal and sum of left diagonal.
Solved using: Python in Excel.