mardi 27 mars 2018

Google Sheets Concatenate an Array of IFs

My goal is to create an Array of IF statements, all independent of each other, and concatenate them together into one cell. I'm currently using an expanded version of this formula:

=CONCATENATE(IF(D2=1,$D$1,""),IF(E2=1,$E$1,""),IF(F2=1,$F$1,""))

I've only posted a few cells, as the current formula goes to column "O" instead of ending at "F". The new spreadsheet I'm working on will go to past CA, and I'd really like to not have to type all the cells out individually.

Is there a way I can repeat this IF statement in an ARRAY so that I can specify the start and end, instead of typing out every IF statement per column?

Aucun commentaire:

Enregistrer un commentaire