If one list is in B1:B4, the other in A1:A10, this seems to work. Change
ranges as necessary:

SUMPRODUCT(--ISNUMBER(MATCH(B1:B4,A1:A10,0)))

"sarora" wrote:


Hi,
I am new to this forum and am trying to explore excel. I want to find
the common names between two columns and get the number of the common
names. how do i do it
Thanks
sarora


--
sarora
------------------------------------------------------------------------
sarora's Profile: http://www.excelforum.com/member.php...o&userid=34860
View this thread: http://www.excelforum.com/showthread...hreadid=546091