Hi there,
What I'm trying to achieve is to show some text in column W, if the previous columns in the same row contain 1 or more certain values.
If i try this formula for 1 value, there is no problem, but when I look for multiple values I fail.
I'm guessing that using an array formula could be a solution? If so, I keep struggling to make this work..
What I'm trying to achieve is to show some text in column W, if the previous columns in the same row contain 1 or more certain values.
If i try this formula for 1 value, there is no problem, but when I look for multiple values I fail.
I'm guessing that using an array formula could be a solution? If so, I keep struggling to make this work..