COUNT

[DME]

I have two column of data as follows:



Column A Column B

IND NE
DEN KC
SEA NO
CIN NYJ
NO SEA
CLE DEN

I need to count the number of matches between the two columns. For
instance, in the above scenario the formula would return the value of 2
since NO and DEN appear in both columns.

I hope this makes sense.

Thanks for the help.

 

[Frank Kabel]

Hi
1. One way:
in C1 enter
=--(COUNTIF($A$1:$A$100,B1)>0)
and copy this down
After this sum column C

2. Another way: Enter the following array formula (entered with
CTRL+SHIFT+ENTER)
=SUM(COUNTIF(A1:A6,B1:B6))



nk Kabel
Frankfurt, Germany

 

[Biff]

Hi!

Here's one way:

Entered as an array: CTRL,SHIFT,ENTER

=SUM(COUNTIF(A1:A6,B1:B6))

BTW, the answer is 3. You missed Seattle!

Biff

 

[DME]

Thanks for the help!

Hi!

Here's one way:

Entered as an array: CTRL,SHIFT,ENTER

=SUM(COUNTIF(A1:A6,B1:B6))

BTW, the answer is 3. You missed Seattle!

Biff