View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Remacricky Remacricky is offline
external usenet poster
 
Posts: 1
Default Count the unique entries in a column of data

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.