I'm trying to use the TEXTJOIN function to create a comma separated list of the content of each row's Column D value, but only when it's Column J value reads "Regulatory" and it's Column K value reads "No".
I can get it to do this with one condition (i.e. only dependent on Column J OR K), but not both conditions (J AND K). The formula I'm using is:
=TEXTJOIN(",",TRUE,IF('Variable Database'!$J$3:$J$762="Regulatory"*('Variable Database'!$K$3:$K$762="No"),'Variable Database'!$D$3:$D$762,""))
It is a valid formula but just returns "#VALUE". Do you have any ideas about how I might achieve this?
Aucun commentaire:
Enregistrer un commentaire