Sat 13 Aug 2016

Article 42 - Generating an Odd Order Magic Square in Excel (VBA)

By |Saturday, August 13th, 2016|Categories: Articles, VBA|Tags: , , , , , , , , , , , |1 Comment

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

(more…)

Tue 14 Jul 2015

Solution - Challenge 15 – Floyd’s Triangle

By |Tuesday, July 14th, 2015|Categories: Solutions|Tags: , , , , , , |0 Comments

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

=IF(COLUMNS($A:A)>ROWS($1:1),"",IF(ROWS($1:1)=1,1,ROWS($1:1)-2+
COLUMNS($A:A)+INDIRECT(ADDRESS(ROW()-1,COLUMN()-COLUMNS($A:A)+1,1))))

The solution workbook is located at Solution - Challenge 15 – Floyd’s Triangle

Sat 23 May 2015

Challenge 15 - Floyd's Triangle

By |Saturday, May 23rd, 2015|Categories: Challenges|Tags: , , , , |1 Comment

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.

1
2 3
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.

1

Note - You may choose to post your response in comments.