Excel Challenge: List numbers that are sum of squares of other numbers
In this Excel challenge, you are required to produce a list of numbers that are the sum of the squares of natural numbers, also the list should be pruned to numbers less than 100(or any other number in a different circumstance)
Link to workbook
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:21 Problem statement
01:19 Breakdown of logic
02:30 Using Helper cells
07:07 Introducing TOCOL function
08:00 2nd Approach
09:18 Solution in one-cell
12:02 concluding thoughts
#excelchallenge #excelformulas