Results 1 to 27 of 27

How to remove duplicated ID but have them add up the values the ID represneted

Threaded View

alcorp How to remove duplicated ID... 07-28-2014, 04:23 PM
hoyasaxa215 Re: How to remove duplicated... 07-28-2014, 04:31 PM
alcorp Re: How to remove duplicated... 07-28-2014, 04:46 PM
hoyasaxa215 Re: How to remove duplicated... 07-28-2014, 04:51 PM
alcorp Re: How to remove duplicated... 07-28-2014, 05:05 PM
FDibbins Re: How to remove duplicated... 07-28-2014, 05:11 PM
alcorp Re: How to remove duplicated... 07-28-2014, 05:20 PM
FDibbins Re: How to remove duplicated... 07-28-2014, 04:56 PM
alcorp Re: How to remove duplicated... 07-28-2014, 05:31 PM
FDibbins Re: How to remove duplicated... 07-28-2014, 06:41 PM
jindon Re: How to remove duplicated... 07-28-2014, 05:49 PM
alcorp Re: How to remove duplicated... 07-28-2014, 06:02 PM
micope21 Re: How to remove duplicated... 07-28-2014, 06:06 PM
alcorp Re: How to remove duplicated... 07-28-2014, 06:30 PM
jindon Re: How to remove duplicated... 07-28-2014, 06:10 PM
alcorp Re: How to remove duplicated... 07-28-2014, 06:33 PM
jindon Re: How to remove duplicated... 07-28-2014, 06:38 PM
jindon Re: How to remove duplicated... 07-28-2014, 06:37 PM
hoyasaxa215 Re: How to remove duplicated... 07-29-2014, 08:51 AM
alcorp Re: How to remove duplicated... 07-29-2014, 04:47 PM
hoyasaxa215 Re: How to remove duplicated... 07-29-2014, 04:54 PM
alcorp Re: How to remove duplicated... 07-29-2014, 05:07 PM
popipipo Re: How to remove duplicated... 07-29-2014, 05:18 PM
alcorp Re: How to remove duplicated... 07-29-2014, 05:38 PM
popipipo Re: How to remove duplicated... 07-29-2014, 05:44 PM
alcorp Re: How to remove duplicated... 07-29-2014, 05:52 PM
mohamedJamsheer Re: How to remove duplicated... 07-29-2014, 06:38 PM
  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    Ontario, CA
    MS-Off Ver
    2010
    Posts
    45

    How to remove duplicated ID but have them add up the values the ID represneted

    Remove duplicate but add values.xlsx

    Hi,

    I have about 800 records and the the unique identifier are the names. Some owners are repeated several times and they have different values for the EDU column in my project. I need to remove any duplicated owners but I need to add up the values of each record that had value so I can get a combined value for one owner instead of a repeated owner with smaller values. How would I go by doing that? A formula or is there a tool in excel? I am lost on this one. I uploaded a sample file so you can see what I trying to do. Thanks.

    BTW i found if the values are the same for the EDU then I can not add them since it is also duplicated. I can only add up the unique values for the EDU
    Last edited by alcorp; 07-29-2014 at 05:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove Duplicated items in combo box
    By FRIEL in forum Excel General
    Replies: 11
    Last Post: 12-03-2012, 04:26 PM
  2. How to remove semi-duplicated text
    By variatsioon in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 12:49 PM
  3. Remove Combobox Duplicated items
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2009, 02:35 AM
  4. Replies: 1
    Last Post: 10-16-2005, 08:05 AM
  5. Remove ALL duplicated records, leaving behind NONE
    By Christopher Dawes in forum Excel General
    Replies: 2
    Last Post: 06-06-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1