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