While working on a project involving creating a URL from a set of information entered in a Google Docs form, I ran into the problem that the concatenate formula does not work as an array formula.
This is a simple solution to allow a simple concatenate that works within =ARRAYFORMULA
=ARRAYFORMULA(A2 & B2:B)
A2 will only include what is in cell A2
B2:B will include everything in column B, except B1
Thank you, Docs Help Forums!
http://productforums.google.com/forum/#!searchin/docs/array$20concatenate/docs/OU6QbGWjkVk/6r3PuWzjRboJ
You can make unused form areas blank by using an IF statement
=ARRAYFORMULA (IF (A2:A > 0, B2 & C2:C, ” “))
Filed under: Uncategorized |
Leave a comment