Differentiate between entire column and current row
Hello, I am struggling to implement a simple "contains" formula. Here's a sample data set and formula: Here's the text: Contains(:Column 1, :Column 2) The issue: I think it is always checking the current row of Column 1 (whole). I want it to check the entire column, not just the current row. You can see the E and B are in Column 2, but the output is saying that it does not find the part in the who...