View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sippan Sippan is offline
external usenet poster
 
Posts: 1
Default Summarizing doubles

I have a rather lengthy list of products sold by the company I work for; one
column with the product name, one column with the number of articles sold.
There are many instances where the same product appears on several rows. I am
looking for a way to remove the doubles in the first column, but summarize
the different values in the second column into one. How?