Hi
try:
=SUMPRODUCT(--(ISNUMBER(MATCH(A1:E1,G1:K1,0))))

--
Regards
Frank Kabel
Frankfurt, Germany

Daniel Bonallack wrote:
In A1:E1, I have 5 bank names
In G1:K1, I have 5 more bank names

In M1, I want to have a formula that counts the number of repeats
between the two sets. (I would then copy this down the 200 rows).

Example, A1:E1 has CSFB, CITI, DB, JPM, MS, and G1:K1 has MS, LB,
BoFA, DB, CITI

The answer in M1 would be 3
Thanks in advance for your help

Daniel Bonallack