Hello!
I have this table:
I would like to check if a cell contains any of the values/strings of Column1 where Column2 is 1.
In a separate formula, I would like to check if a cell contains all the values/strings of Column1 where Column2 is 1.
Thanks!
I have this table:
A | 1 |
B | 0 |
C | 1 |
I would like to check if a cell contains any of the values/strings of Column1 where Column2 is 1.
In a separate formula, I would like to check if a cell contains all the values/strings of Column1 where Column2 is 1.
Thanks!