View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sitetidy
 
Posts: n/a
Default Merge data in column function


Hi all,

I've a speadsheet with two columns clicks and domains.

Domains has repeat entries in and I would like to produce a new table
with only unique values for the domain. My question is how would I do
this and add combine the relevant click values

i.e.

www.google.com 10
www.yahoo.com 07
www.google.com 12

Would end up as:
www.google.com 22
www.yahoo.com 07

Thanks,


Richard


--
sitetidy
------------------------------------------------------------------------
sitetidy's Profile: http://www.excelforum.com/member.php...o&userid=33274
View this thread: http://www.excelforum.com/showthread...hreadid=530992