Challenge No. 33: Provide a formula to generate the sequence shown (A till Z only).
Solved using: Power Query (List.Transform).
⭐️ Beginner
Easy challenges for newcomers.
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).
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).
List Numbers After Last Eight
Challenge No. 23: Provide a formula to list all numbers greater than 8 after last 8 in A2:A20.
Solved using: Python in Excel.
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.
Find Common Animals
Challenge No. 13: Provide a formula to generate the list of animals who are common in all 3 columns.
Solved using: Python in Excel.