I want to use formulatext() with arrayformula() :
=arrayformula(formulatext(A1:A10))
But The arrayformula
doesn't work. It should output 10 rows but it only returns a single row output.
Is there anyway around to combine them ?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI want to use formulatext() with arrayformula() :
=arrayformula(formulatext(A1:A10))
But The arrayformula
doesn't work. It should output 10 rows but it only returns a single row output.
Is there anyway around to combine them ?
It would probably be easiest to just use =iferror(formulatext(A1))
and fill the formula down.
The formulatext()
function is not array enabled and will only return the formula in the top left cell of its parameter range, regardless of whether you are using an arrayformula()
wrapper or not.
To get the formulas in a A1:A10
, you will have to fill the formula down. To get them in one go, you would need a script.