A magic square needs no introduction and we come across it many times. A magic square is a square grid and the minimum size of a magic square is 3x3. The whole numbers in magic square appear only once and all cells are filled. The horizontal rows, vertical columns and main and secondary diagonals all add up to the same number. This number is called magic constant. The more about magic square can be read here - https://en.wikipedia.org/wiki/Magic_square
Below is a proposed solution for the challenge Challenge 15 – Floyd’s Triangle
Put this formula anywhere in your sheet and drag right and down
The solution workbook is located at Solution - Challenge 15 – Floyd’s Triangle
Wikipedia article related to Floyd's Triangle will give you details about this. But, one look at below and you will understand what is this.
4 5 6
7 8 9 10
11 12 13 14 15
16 17 18 19 20 21
22 23 24 25 26 27 18
Now, the challenge before you is to give me a formula which can be put anywhere in the Excel and can be dragged down and right to generate the above triangle.
Hence, if I put the formula in C3 and copy the formula in the range C3:H8, the below Grid should be generated which is Floyd's Triangle.
Note - You may choose to post your response in comments.