Hello,
I'm using a formula to basically create an Array that looks something like this:
{1,1,0; 1,1,1; 1,0,0; 0,0,0}
and i'm trying to turn it into this:
{0;1;0;0}
by multiplying the rows together, so I can find if there are any instances where all are true.
The formula that's creating the array looks something like:
=--isnumber(search(A1:A3, List))
Perhaps I'm approaching this problem in the wrong way. Any help or guidance would be greatly appreciated.
Thank you!
I'm using a formula to basically create an Array that looks something like this:
{1,1,0; 1,1,1; 1,0,0; 0,0,0}
and i'm trying to turn it into this:
{0;1;0;0}
by multiplying the rows together, so I can find if there are any instances where all are true.
The formula that's creating the array looks something like:
=--isnumber(search(A1:A3, List))
Perhaps I'm approaching this problem in the wrong way. Any help or guidance would be greatly appreciated.
Thank you!
Last edited: