Excel Comparing two Columns

June 15, 2009 at 14:24:44
Specs: Windows XP
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
isp.s01000.cn F
isp.s01000.cn F
isp.s01000.cn P

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.

See More: Excel Comparing two Columns

Report •

June 15, 2009 at 14:25:22
There is an Office software forum here.

Report •

June 15, 2009 at 18:10:26
You should learn a programming language. A simple one like
BASIC will allow you too make all sort of comparisons and

Report •

Related Solutions

Ask Question