Assuming that each item in the first list occurs only once, but in the
second list occurs variable numbers of times and that both lists are in
column A
In column B on the first list, starting with cell B1
=COUNTIF(Sheet2!A:A,Sheet1!A1) and copy down,

If you have multiple occurances on both lists, but only want to count
the number once on the first list

=IF(COUNTIF($A$1:A1,A1)1,"",COUNTIF(Sheet2!A:A,Sh eet1!A1))
and copy down

Hope this helps


--
flydecoder
------------------------------------------------------------------------
flydecoder's Profile: http://www.excelforum.com/member.php...o&userid=27288
View this thread: http://www.excelforum.com/showthread...hreadid=468080