Challenge No. 40: Provide a formula to find common unique alphabets between 2 cells in same row.
Solved using: Power Query.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Toggle Alphabet Case
Challenge No. 36: Provide a formula to reverse the case of English alphabets.
Solved using: Power Query.
Generate Pascal’s Triangle
Challenge No. 35: Provide a formula to create the triangle shown.
Solved using: Power Query.
Extract last group of digits from string
Challenge No. 34: Extract the last group of numbers from a given string.
Solved using: Python in Excel.
List Local Temperature Peaks
Challenge No. 32: Provide a formula to list the dates when temperature has been greater than previous day and next day both.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Knn Missing Value!
Challenge No. 86: K-nearest neighbors (KNN) is a simple technique for replacing missing values with the average of the nearest values.
Solved using:Excel, Power Query, and VBA.
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.
Validate ISBN-10 Numbers
Challenge No. 29: List all books from A2:A10 which have a valid ISBN-10 number.
Solved using: Python in Excel.
Find Nth Two Against Letters
Challenge No. 28: Considering only alphabets in column A2:A20, find the alphabet corresponding to 5th 2 in column B.
Solved using: Power Query (Table.SelectRows).
Filter Candidates by Skill Match
Challenge No. 27: A1:C9: List of candidates with their primary and secondary skills.
Solved using: Power Query (List.Intersect, Text.Split).