arrayThis AddonAvailable on:
Chrome Web Store Google Apps Marketplace Short Description Copies the formula of the top leftmost cell across a range, respecting absolute and relative cell references. 
Long Description
Copies the formula of the top leftmost cell across a range, respecting absolute and relative cell references. This is useful for applying functions across arrays that cannot normally be applied with ARRAYFORMULA(), such as RAND() & GOOGLEFINANCE().
For reference, Google's list of functions can be found here.
Screenshots
Copies the formula of the top leftmost cell across a range, respecting absolute and relative cell references. This is useful for applying functions across arrays that cannot normally be applied with ARRAYFORMULA(), such as RAND() & GOOGLEFINANCE().
For reference, Google's list of functions can be found here.
Screenshots

How To Use
To get started, highlight the range you want to apply the formula across. Remember that the formula will be taken from the topleft cell and that absolute and relative cell references are maintained. Go to 'Addons > arrayThis > Active Range' and you will see the formula copied across the range.
If you wish to apply arrayThis across several ranges at once, then you do not need to select them. Go to 'Addons > arrayThis > Enter Range' and enter the ranges, separating by commas. Note that if you wish to apply several formulas in different columns/rows then you must enter them separately as "A:A,B:B", not "A:B".
To get started, highlight the range you want to apply the formula across. Remember that the formula will be taken from the topleft cell and that absolute and relative cell references are maintained. Go to 'Addons > arrayThis > Active Range' and you will see the formula copied across the range.
If you wish to apply arrayThis across several ranges at once, then you do not need to select them. Go to 'Addons > arrayThis > Enter Range' and enter the ranges, separating by commas. Note that if you wish to apply several formulas in different columns/rows then you must enter them separately as "A:A,B:B", not "A:B".
Output
The addon will overwrite the cells in each range with the formula of the topleft cell in the range. You will see the output of this formula in each cell.
The addon will overwrite the cells in each range with the formula of the topleft cell in the range. You will see the output of this formula in each cell.
Examples
A1: =RAND()
Select column A. Go to 'Addons > arrayThis > Active Range'. The output will be '=RAND()' in each cell, producing different random numbers, instead of the same random number that would be produced by ARRAYFORMULA().
A1: ="http://www.example.com/?n="&RAND()
B1: =IMPORTHTML(A1,"table",1)
Incorrect: Go to 'Addons > arrayThis > Enter Range' and enter "A:B" in the prompt. This will make every cell in A:B ="http://www.example.com/?n="&RAND().
Correct: Go to 'Addons > arrayThis > Enter Range' and enter "A:B" in the prompt. This will make every cell in column A '="http://www.example.com/?="&RAND()' and every cell in column B '=IMPORTHTML(A1,"table",1)'.
A1: =RAND()
Select column A. Go to 'Addons > arrayThis > Active Range'. The output will be '=RAND()' in each cell, producing different random numbers, instead of the same random number that would be produced by ARRAYFORMULA().
A1: ="http://www.example.com/?n="&RAND()
B1: =IMPORTHTML(A1,"table",1)
Incorrect: Go to 'Addons > arrayThis > Enter Range' and enter "A:B" in the prompt. This will make every cell in A:B ="http://www.example.com/?n="&RAND().
Correct: Go to 'Addons > arrayThis > Enter Range' and enter "A:B" in the prompt. This will make every cell in column A '="http://www.example.com/?="&RAND()' and every cell in column B '=IMPORTHTML(A1,"table",1)'.
Having Trouble?
Contact me, giving as much detail as you can.
Contact me, giving as much detail as you can.
Enjoying this addon?
Consider donating so that I can keep development going.
Consider donating so that I can keep development going.
Changelog
 20170817  Initial Version.