+ Reply to Thread
Results 1 to 2 of 2

Need to combine like rows by duplicates in 2 columns

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Need to combine like rows by duplicates in 2 columns

    I asked about this on another forum but got zero help. Maybe someone here can help. I tried to write a macro but its just not doing what i need it to do.

    I have a spreadsheet of scrap part data that i need to combine. The key identifiers are a "job" column and then a "defect" column. I would like the macro to combine the similar job numbers and defects, summing the qty of duplicate defects/job numbers

    Not sure if this explanation is sufficient to get my point across so i included a worksheet with what the final combined data should look like

    "RawData" is the data needed to be combined.
    "Sheet1" is the results when i run the macro i tried to write.
    "needed results" is the final results i need the macro to do(i did that sheet by hand)

    I really appreciate any help givin!!!

    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2003,excel 2007

    Re: Need to combine like rows by duplicates in 2 columns

    why not use pivot data (macro is not required)

    see the attachment "toolman pivot table.xls"
    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)


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