|I am attempting to compare two different columns. In this case, I am seeking specifically anything that has ".cn" in column A, and the letter "F" in column B.|
So, the data I have is this:
Colum A Column B
the formula I am using is (please note, the data starts at row 10in both cases):
I've tried this as an Array, and as a basic formula..neither works. Now, in this example, it "should" return 2 as there are 2 instances where Column A has a ".cn" in it, and the directly connected cell B is "F"
Any assistance would be greatly appreciated.