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

How can the font and size of (all) citation numbers be altered? 1
Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Duplicate entry in a column/row 14
Data Lookup Question 1
Counting number of items excluding duplicates. 1
Page numbering with Merged Document and IF statements 1
Merging from an Excel file with graphics 1

Top