Try
=COUNTIF(Sheet2!$A$1:$A$15,A1)
to get the count of A1 in Sheet2!A1:A15
change 15 to your last row. Because of absolute reference you can copy it
down...

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Steve" wrote:

hope you can help me!

i have one workbook, two worksheets

in the first worksheet i have a list of names
in the second a list of names with outcomes.
the second sheet has many of the same names, with different outcomes.

I would like to find, if the name matches the one on the first sheet how
many records there are for this name and display a summary for different
outcomes.

thank you.