For example, to repeat a range 3 times: Vertical: =REPTA(A1:C5, 3) Horizontal: =REPTA(A1:C5, 3, 1) Efficiency is relative to the size of the array. Smaller arrays will perform faster than larger arrays. The 5x3 array in the example shown above can output to column XFD without any noticeable calculation lag, using =REPTA(A1:C5, 5460, 1).

How do i calculate the probability of a result happening X amount of times in a row? Imagine an event with 6 possible outcomes. 1st outcome has chance of 40%, 2nd has a chance of 20%, 3rd 15%, 4th 10%, 5th 10%, 6th 5%.

Calculating the odds of a specific outcome happening X amount of times ...

Why is $1+2+3+4+\ldots+n = \dfrac {n\times (n+1)}2$ $\space$ ? Not appropriate for an answer, but you've asked either a very easy or a very difficult question. If by "why" you mean, "Can I see a proof of this fact?" the question is fairly easy to answer. If by "why" you mean, "Why should this be true?" you've asked a very deep kind of question that mathematicians make entire careers out of ...

The solution is to restore the table N times by using UNDROP; and it only works if there is no table with the same name. N is a number of times the table is recreated using CREATE OR REPLACE; and time travel doesn't work as CREATE OR REPLACE drops the table and recreates it. I have created a table with some dummy data to test it.