+ Reply to Thread
Results 1 to 3 of 3

Handling duplicate values into unique and sum their next column values

  1. #1
    Registered User
    Join Date
    01-26-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    2

    Handling duplicate values into unique and sum their next column values

    Hi guys,

    Im trying to solve a problem but, obviously i need some help from the experts.

    To take things from start, I open a txt file and read the data I need to an array, then I paste the required values on a sheet.

    Example A:
    Raw Data.PNG

    As you can see in column A there are duplicates values from which, with the help of dictionary in vba i sort the list as shown below:

    Example B:
    Capture.PNG

    But the problem is that in the example B i manage to short the list not to exist duplicates values in the column A (Order N.) also in column B (Invoice N.) i manage to link all the invoices with the order N. but in column C (Amount) i want to sum the values for each cell.

    like this :
    Result.PNG


    I would apreciate if anyone can help.
    Last edited by No_feelings; 04-26-2012 at 04:33 PM. Reason: Change title

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Handling duplicate values into unique and sum their next column values

    Hi and welcome to the forum.(Kαλώς ήρθες)

    Be sure, that best way to describe your problem, is to upload a sample workbook. Not Pictures.


    Edit: No feelings....????
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-26-2011
    Location
    Greece
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Handling duplicate values into unique and sum their next column values

    Hi Fotis and thank you for your welcome and quick response.


    Edit: No feelings....????
    )


    Be sure, that best way to describe your problem, is to upload a sample workbook. Not Pictures.
    I agree, ill keep that in mind for next time.

    I have attached my workbook with three sheets. each one is as decribed in my first post.

    PS I dont have any VBA code inside cause my working book is in other file, but if you need it i can post it.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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