count number of instances of same data

G

George

Hello,
I have a worksheet with 2159 rows. Each row contains 2 columns (name and
number) with many duplicates.
I want to end up with a report that shows 3 columns (name, number,
instances) where there are no duplicates but the instances column shows the
number of times each name and number appears.
I think a pivot table is the solution but I can't get it to do what I want.
Can anyone help me with this?

Thanks!
 

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

Data Lookup Question 1
Counting number of items excluding duplicates. 1
consolidate data in pivot table 1
COUNT function - # of occurences a number appears in all cells 26
Pivot tables - counting unique numbers 2
find unique records 8
Need to add Sequence/Instance Number to Duplicate Records 3
Missing row numbers 3

Top