Challenge No. 25: Provide a formula to populate Yes or No against given 3×3 magic squares.
Solved using: Power Query (List.Transform).
⭐️⭐️ Easy
Slightly challenging problems for learners.
Normal Distribution!
Challenge No. 84: Normal distribution was a kind of nightmare in university for me, but now let’s solve it using Excel.
Solved using:Excel (HSTACK, IF, INDEX), Power Query (Table.AddColumn), Python, Python in Excel, R, and VBA.
List Valid IP Addresses
Challenge No. 22: Provide a formula to list all valid IP addresses from A2:A12.
Solved using: Power Query.
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.
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.
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.
Generate result table from Alphabets
Challenge No. 3: (Excel formulas also welcome)
Generate the result table from Alphabets table.
Solved using: Power Query (List.Distinct).
List Numbers Appearing Repeatedly
Challenge No. 6: Provide a formula to list numbers which appear more than once in Range A2:A20 and have both B and C in B2:B20.
Solved using: Python in Excel.