New answers tagged


CONCATENATE will try to join everything inside its parentheses; so applying it to an entire column will cause Sheets to try to form one string from all data in that column, hence the limit error. The ampersand alone does this in arrays. This is how I would approach this (keeping in mind that I can't see your actual data): ArrayFormula(IF(A:A="",,IF(...

Top 50 recent answers are included