excel

Excel: Put formula in next row after header text, like in Google Sheets


In Google Sheets, I'm able to use curly braces to enter a series of values that can either be just text or formulas, and Sheets will calculate the formulas. For example, if I were to do ={"names";textjoin(",",,E1:F1)} what would happen is, Names would appear in the cell and one the next row, the textjoin would calculate and produce a result.

The purpose is to make sure the formula is always there even when I delete rows in the dataset so that I don't have to keep writing in the formula.

I can't seem to do this in Excel, I get an error message "there's a problem with this formula".

Is there a way to do this in Excel? I use Google Sheets for personal things, but I have to use Excel at work.


Solution

  • MS Excel have VSTACK() function. Try-

     =VSTACK("Names",TEXTJOIN(",",1,E1:F1))