I'm trying to create a formula that returns with all the text values for all the conditions. So similar to a sumproduct where the formula returns a summed value of ALL the conditions i need the same but for text. Any ideas???
hello no
hello no
hello yes
goodbye no
formula would return with (no, no, yes).
hello no
hello no
hello yes
goodbye no
formula would return with (no, no, yes).