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.s00003.jp
isp.s01000.cn F
isp.s01000.cn P
isp.s01000.cn
isp.s01000.cn

the formula I am using is (please note, the data starts at row 10in both cases):

=SUMPRODUCT(--($A$10:$A$19="*.CN"),--($B$10:$B$19="F"))

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 •


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

Report •

#2
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
selections.

Report •

Related Solutions


Ask Question