vendredi 28 février 2020

Excel Return Array if condition is true

I am trying to get something of the effect that when I have an if statement: if({TRUE;FALSE;TRUE},{1,2,3}) it will return with {1,3} is there any way to get this effect with an array of conditions and return an array of results?

Aucun commentaire:

Enregistrer un commentaire