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.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Check Lexically Sorted Dates
Challenge No. 507: List the dates which are lexically sorted.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Interleave Numbers into Letters
Challenge No. 506: Concat column B numbers into column 1 alphabets.
Solved using: Python.
List First 10 Tech Numbers
Challenge No. 494: Generate the first 10 Tech Numbers.
Solved using: R.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Extract Date Day and Time
Challenge No. 68: Extract the Date, Day of the Week and Time
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: R.
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.
Sequential Number Labeling
Challenge No. 490: Fill down the numbers with following logic.
Solved using: Python in Excel.
Subset Sum to Target
Challenge No. 488: This problem is contributed by Mehmet Çiçek
Find the numbers from column A which add up to the total given in column B.
Solved using: Python in Excel.