+ Reply to Thread
Results 1 to 7 of 7

Remove duplicates and sum up their values

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Remove duplicates and sum up their values

    Good day!
    Any solution for this?
    Capture.PNG
    1. I already remove the duplicates and sum up their values
    but I cannot include the data with same code but different RAL
    For Example :
    the Code: 1001 (highlighted in yellow) with RAL 3008
    I cannot include in table 2
    here is my workbook.
    Book1.xlsm
    Thanks in advance.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Remove duplicates and sum up their values

    Instead of Using Advance Filter make use of Remove Duplicates

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Remove duplicates and sum up their values

    Thanks man..
    Is it possible to copy the unique values in another cell?
    Because i want to retain the original values.
    And i want to sum-up their values.
    Last edited by Ryan_Bernal; 10-17-2013 at 03:19 AM.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Remove duplicates and sum up their values

    Before applying the remove duplicate just copy paste the original data to some other area and use the Remove Duplicates code on the newly pasted source…

  5. #5
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Remove duplicates and sum up their values

    I also need to sum up their values (X&Y).
    As you noticed in my table 2, i need to look up for the code so that i can sum up the values of the duplicates.
    I am not just removing the duplicates.
    Hope you can help on this.
    Last edited by Ryan_Bernal; 10-17-2013 at 03:31 AM.

  6. #6
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Remove duplicates and sum up their values

    remove row 1 before running this code

    Please Login or Register  to view this content.
    Last edited by snb; 10-21-2013 at 04:06 AM.



  7. #7
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Remove duplicates and sum up their values

    Problem solve into this forum.
    http://www.ozgrid.com/forum/showthread.php?t=183525.
    By the way thanks snb for your support.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 01-12-2013, 11:36 PM
  2. [SOLVED] Unique Values Without Remove Duplicates
    By Camel in forum Excel General
    Replies: 25
    Last Post: 07-20-2012, 04:17 AM
  3. Excel 2007 : return TXT Values and remove duplicates?
    By fordzilla in forum Excel General
    Replies: 0
    Last Post: 09-29-2011, 06:20 PM
  4. Replies: 1
    Last Post: 05-24-2011, 04:04 AM
  5. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 PM

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