## Solution - Challenge 61 - Generate Multiplication Table

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)

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),"")

Mon 24
Oct 2016

Below is a possible solution to the challenge **Challenge 52 - Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5...**

Put following formula and drag down

=FLOOR((1+((1+8*ROWS($1:1)-1)^0.5))/2,1)

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.

Sat 24
Sep 2016

This time challenge before you is to write a formula which generates a sequence where every digit appears that many times as that digit. Hence, 3 will repeat 3 times, 8 will repeat 8 times and so on..Hence, the exact sequence would be 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5,6,6,6,6,6,6,7,7,7,7,7,7,7.....

*The solution to above challenge will be published after a month i.e. on 24-Oct-16.*

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

Mon 18
Jul 2016

Below is a possible solution to the challenge - Challenge 45 - Number of Days Passed in a Quarter

The formula to calculate number of days passed in a quarter is

=A1-DATE(YEAR(A1),(ROUNDUP(MONTH(A1)/3,0)-1)*3+1,1)

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

Sat 18
Jun 2016

This time the challenge is - If a date is given, what would be the formula to find the number of days passed in a quarter.

If A1 has the value 12-Mar-16, then 31 days in Jan, 29 days in Feb (2016 is a leap year) and 11 days in Mar = 31+29+11 = 71 days have passed in Q1. Hence, answer is 71.

If A1 has 15-Apr-16, then 14 days have passed in Q2. Hence, answer is 14.

If A1 has 28-Aug-16, then, 31 days in Jul and 27 days in Aug = 31+27 = 58 days have passed in Q3. Hence, answer is 58.

You need to give the formula to find the above.

*The solution to above challenge will be published after a month i.e. on 18-Jul-16.*