## Downloads 15 - Excel Formulas Bible

This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.

Download it from **Excel - Formulas Bible**

Sat 06
May 2017

This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.

Download it from **Excel - Formulas Bible**

Mon 01
May 2017

Below is a possible solution to the challenge - **Challenge 61 - Generate Multiplication Table**

Put following formula and drag right and down -

=ROWS($1:1)*COLUMNS($A:A)

Sat 01
Apr 2017

Tue 22
Nov 2016

Below is a possible solution to the challenge **Challenge 54 - Make a Sequence like A B C D E F......**

Put below formula as array formula in a cell and drag down

=IFERROR(CHAR(MATCH(ROWS($1:1),(ROW($1:$26)*(ROW($1:$26)+1))/2,0)+64),"")

Sat 22
Oct 2016

This time challenge before you is to write a formula which can be dragged down and leaves so many blank cells - 1 before that alphabet's position in English Language. Hence, the sequence will start with A, will leave 1 blank cell, then B, then 2 blank cells, then C, then 3 blank cells, then D, then 4 blank cells, then E, then 5 blank cells, then F....................................................................then 24 blank cells, then Y and finally 25 blank cells and then Z.

Sun 13
Mar 2016

Below is a possible solution to **Challenge 36 – Generate Triangular Numbers.**

Enter below formula anywhere and drag down -

=IF(ROWS($1:1)=1,1,INDIRECT(ADDRESS(ROW()-1,COLUMN()))+ROWS(($1:1)))

A workbook containing the above solution can be downloaded from **Solution - Challenge 36 – Generate Triangular Numbers.**

Edit - 23-Aug-16 - A better solution is to use below formula and drag down

=ROWS($1:1)*(ROWS($1:1)+1)/2

Sat 13
Feb 2016

If interested in details about Triangular Numbers, you can refer to following link (though it is not needed and one look at the sequence, you will understand what it is)

https://en.wikipedia.org/wiki/Triangular_number

It is, basically, the following sequence -

1, 3, 6, 10, 15, 21, 28, 36, 45, 55, 66, 78, 91, 105, 120, 136, 153, 171, 190, 210, 231, 253, 276, 300, 325, 351, 378, 406

The challenge is to write a formula **which can be put down in any cell** and which when dragged down will generate the above sequence.

Hence, if I put the formula in say A1, it should generate the above sequence. Same formula if put in C4 and dragged down, should generate the above sequence. Same formula if put in F8 and dragged down, should generate the above sequence. Hence, the formula should not require any tweaking to generate the sequence in different columns. Same formula should work in any cell.

*The solution to the above challenge will be published after a month i.e. on 13-Mar-16.*