+ Reply to Thread
Results 1 to 8 of 8

Help returning part number 1 time and adding up like part number QTY

  1. 09-13-2014, 12:15 AM #1
    SOLERSA
    SOLERSA is offline
    Registered User
    Join Date
    09-11-2014
    Location
    ORLANDO, FL
    MS-Off Ver
    OFFICE 2007
    Posts
    5

    Help returning part number 1 time and adding up like part number QTY

    *
    Would like to compare data on SHEET 2 and return information to SHEET 1. Compare column A and return Part Numbers only once then compare like Part Number QTYs (C) and return added Qtys.

    A B C
    1111111 PN#1 2
    1111111 PN#1 3
    222222222 PN#2 1
    222222222 PN#2 1
    222222222 PN#2 1
    222222222 PN#2 1
    222222222 PN#2 1
    222222222 PN#2 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1
    3333333333 PN#3 1


    Sheet 1 should look like.

    A B C
    1111111 PN#1 5
    Reply With QuoteRegister To Reply
  2. 09-13-2014, 12:17 AM #2
    SOLERSA
    SOLERSA is offline
    Registered User
    Join Date
    09-11-2014
    Location
    ORLANDO, FL
    MS-Off Ver
    OFFICE 2007
    Posts
    5

    Re: Help returning part number 1 time and adding up like part number QTY

    Sorry for the way it looks. Being in Afghan I can't upload the spread sheet. To clarify there are 3 columns (A, B and C) A is the part number, B is the description and C is the qty.
    Reply With QuoteRegister To Reply
  3. 09-13-2014, 12:29 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Help returning part number 1 time and adding up like part number QTY

    Hi, welcome to the forum

    Being in Afghan I can't upload the spread sheet.
    why cant you upload a w/b here? (your location said Orlando FL, anyway?)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 09-13-2014, 01:22 AM #4
    SOLERSA
    SOLERSA is offline
    Registered User
    Join Date
    09-11-2014
    Location
    ORLANDO, FL
    MS-Off Ver
    OFFICE 2007
    Posts
    5

    Re: Help returning part number 1 time and adding up like part number QTY

    Unfortunatly, I can't load anything from my desktop due to security reasons. My profile is set up with Orlando, but I am on the other side of the world.'

    If anything I can upload the W/B from my personal laptop when I can. The MWR internet isn't that reliable but worth a try.
    Reply With QuoteRegister To Reply
  5. 09-15-2014, 01:31 AM #5
    SOLERSA
    SOLERSA is offline
    Registered User
    Join Date
    09-11-2014
    Location
    ORLANDO, FL
    MS-Off Ver
    OFFICE 2007
    Posts
    5

    Re: Help returning part number 1 time and adding up like part number QTY

    See attached file to clarify what I am looking for in a formula.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 09-15-2014, 02:39 AM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Help returning part number 1 time and adding up like part number QTY

    With an pivot table.

    See the attached file.

    I changed the format of the quantity column in numbers instead of text.`



    Som van *Quantity*
    *Unitofissue* *Partnumber* Totaal
    EA 1111111 5
    222222222 6
    3333333333 9
    Totaal EA 20
    Eindtotaal 20
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  7. 09-15-2014, 04:49 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

    Re: Help returning part number 1 time and adding up like part number QTY

    Pl see attached file with formulas.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 09-16-2014, 06:31 AM #8
    SOLERSA
    SOLERSA is offline
    Registered User
    Join Date
    09-11-2014
    Location
    ORLANDO, FL
    MS-Off Ver
    OFFICE 2007
    Posts
    5

    Re: Help returning part number 1 time and adding up like part number QTY

    This is exactly what I am looking for, but what if I have a spread sheet of 3000 line items to evaluate?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. drop the whole number and leave the decimal part of the number for calculations
    By RIBSTONE in forum Excel General
    Replies: 1
    Last Post: 02-09-2013, 10:57 PM
  2. Find Part number through Macro and output to associated part to certain cell
    By boylers75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 04:32 PM
  3. How can we use COUNTIF on Number format to count any part of the number
    By BlastRanger in forum Excel General
    Replies: 4
    Last Post: 12-09-2010, 06:57 AM
  4. Returning the Time part from NOW()
    By ElmerS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2010, 04:07 AM
  5. [SOLVED] Selecting the first time a number appears (part 2)
    By Jaydubs in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 09:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1