match 2 cells and count records

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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.
 
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...
 
Back
Top