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
Watch video Excel Challenge: List numbers that are sum of squares of other numbers online without registration, duration hours minute second in high quality. This video was added by user ExcelMoments 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 621 once and liked it 40 people.