Challenge No. 508: List first 500 numbers (skip single digit numbers) where number is a perfect square and also sum of squares of its digits is also a perfect square.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Presidents with Same Initials
Challenge No. 504: List those presidents’ names whose first characters of all parts of names are same.
Solved using: Excel VBA.
Generate Lynch Bell Numbers
Challenge No. 499: Lynch Bell Numbers – Generate the first 500 Lynch Bell Numbers starting with 2 digits.
Solved using: Excel VBA.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
Date Cipher Decryption
Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python in Excel.
Repeat Pythagorean Triplet Finder
Challenge No. 491: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Salesperson Commission Breakdown
Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Find Pythagorean Triplets
Challenge No. 484: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.