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:KevinBrunner_2-1694158597655.png 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 d...
jay_holavarri