TheAssetMgr
Board Regular
- Joined
- Nov 8, 2011
- Messages
- 63
I have a column with values that look like: C-18,C-27,C-33,C-21 or C-21,C-25. The number of C-x values separated by a commas varies from row to row within the column.
What I need to do is drop a formula in an adjacent column that looks at the array in the first column to see if it contains a C-32 or C-33 or C-34 or C-35. If the array contains NONE of those values then I want to see "Error" in the formula column.
Thoughts?
What I need to do is drop a formula in an adjacent column that looks at the array in the first column to see if it contains a C-32 or C-33 or C-34 or C-35. If the array contains NONE of those values then I want to see "Error" in the formula column.
Thoughts?