How can I get a sum total of total dulplicates for each item in a row?

I have list of items in Column A. Some of the items have duplicates. I know that I can get a unique list of items with duplicates removed by using

Tools->Filter->Advanced Filter

Check the "Copy to another location"
Choose Column A as "List Range"
Choose Column B as "Copy to"
Then check "Unique records only"

This gives me everything in column A minus the duplicates.

What I need is a sum total of each item.

For example:

Item
9990053651
9990053651
9990053654
9990053654
9990053654
9990053654
9990053654
9990053654
9990053654
9990053659

I need something like

Item Total
9990053651 2
9990053654 7
9990053659 1

Whats the best way to do this?

Originally Posted by NBVC

Pivot Tables

I just need a list with column a with the item#s and column b with the total of each item#.

Using a Pivot Table, I need to select each item separately to see the total. Unless I am doing something wrong.

Thanks! Thats what I needed

Now I need to make a macro that does this automatically