View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
charles charles is offline
external usenet poster
 
Posts: 124
Default how to sum contents of duplicate rows

Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names
and column 2 has salary.
Charles 15
John 20
John 15
Peter 50

I woul like to see (end result) something like this (note duplicate gone but
salary summed up)

Charles 15
John 35
Peter 50


Thank You Regards Charles