View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default How to remove duplicates and combine their unique values?

Hi again!

I have a list which contains duplicates and values attached to every entry.
Like this:

col a col b
0 5
0 11
1 7
2 5
....

And I would like to make the list look like this:

col a col b
0 16
1 12
....

So, how to do this? Please I need your help!
-Dave