Challenge No. 25: Provide a formula to populate Yes or No against given 3×3 magic squares.
Solved using: Power Query (List.Transform).
SEQUENCE
Generates a sequence of numbers in an array 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.
Caesar Cipher for Digits
Challenge No. 11: Cryptography Challenge – Caesar’s Cipher
Shift the each digit by values given in column B.
Solved using: Python in Excel.
Total Distance!
Challenge No. 81: The distance between cities and staff travels are provided in the question distance and travel tables.
Solved using:Excel (DROP, IFNA, INDEX), Power Query (Table.AddColumn), Python, and R.
Count Letters and Digits
Challenge No. 7: Provide a formula to count the number of English alphabets and numeric digits in every cell.
Solved using: Python in Excel.
Convex Hulls (Gift Wrapping Algorithm)!
Challenge No. 80: The Convex Hull Algorithm leads to the smallest convex area (Polygon) that includes all the points in the dataset.
Solved using:Excel, Python, and R.
Extract From Text! Part 2
Challenge No. 78: Extract all the Dates from the text provided in the question table in different formats.
Solved using:Excel, Power Query, Python, R, and VBA.
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.