One quick way ... use a pivot table (PT)

Insert 2 top col labels, eg:

Type No
Dog 5
Cat 3
etc

Select any cell within the table
Click Data Pivot table. Click Next Next.

In step 3 of the wiz. click Layout
Drag n drop Type within the ROW area
Drag n drop No within the DATA area
Click OK Finish. That's it.

Hop over to the PT sheet for the results ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Remacricky" wrote:
Hi,

I have:

Col A Col B
Dog 5
Cat 3
Boy 2
Dog 3
Cat 9
Boy 1


How can I "filter" this list down so it shows that I have:

Col A Col B
Dog 8
Cat 12
Boy 3

I need to bulk unique entries, while adding their counts (sum) together.

Thanks in advance for any suggestions.