match 2 cells and count records

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.
 
S

Sheeloo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match name and show total result 2
Counting by Two Columns of Variables 9
Some macros not working on shared workbook 8
Populate Data from Summary Sheet 5
Summary Report - multiple dates 1
Drop down list query 2
Match 2 columns to 2 columns in different worksheets 6
Alternative copy/delete method needed 2

Top