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
Below is a possible solution to the challenge - Challenge 61 - Generate Multiplication Table
Put following formula and drag right and down -
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
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.
Below is a possible solution to the problem - Challenge 47 - Generate Pentagonal Series
Put following formula and drag down -
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 -
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.
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.
Below is a possible solution to Challenge 36 – Generate Triangular Numbers.
Enter below formula anywhere and drag down -
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