## 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.

Tue 16
Aug 2016

Below is a possible solution to the problem - **Challenge 47 - Generate Pentagonal Series**

Put following formula and drag down -

=ROWS($1:1)*(3*ROWS($1:1)-1)/2

Tue 02
Aug 2016

Below is a possible solution to the challenge – **Challenge 46 – Compute Numerological Sum for a Name**

The formula to calculate Numerological Sum for a Name would be -

=MOD(SUMPRODUCT(MOD(CODE(MID(SUBSTITUTE(LOWER(A1)," ",""),

ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1," ","")))),1))+2,9)+1)-1,9)+1

Sat 16
Jul 2016

Pentagonal number series is following - 1, 5, 12, 22, 35, 51, 70, 92, 117, 145, 176....

You need to write an Excel formula which can be dragged down and generates the above sequence.

**The solution to this problem will be published after a month i.e. on 16-Aug-16.**

Sat 02
Jul 2016

I had posted **Tips & Tricks 119 – Numerology Sum of the Digits aka Sum the Digits till the result is a single digit.** In this, I had explored how to add a number and arrive at a single digit. For example, if you have to add 8 + 7 the answer would be 15. You need to further add up 1 and 5 of 15 and final answer would be 6. And this is numerological sum.

In numerology, we calculate the digits corresponding to a name. All alphabets carry a number corresponding to 1 to 9. A has 1, B has 2......I has 9, J has 1...R has 9 , S is 1...Z is 8 as illustrated in the table below.

Hence, if my name is Vijay, then I need to add 4 + 9 + 1 + 1 + 7 = 22 = 2+2 = 4

Hence, if a person's name is Julia Richards, then following will be numerological sum = 1 + 3 + 3 + 9 + 1 (Corresponding to Julia) + 9 + 9 + 3 + 8 + 1 + 9 + 4 + 1 (Corresponding to Richards) = 61 = 6 + 1 = 7

Challenge before you is to find a formula which calculates Numerological Sum for a given name if name is given in cell A1.

**The solution to this problem will be published after a month i.e. on 02-Aug-16.**

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