Results 1 to 5 of 5

Look up and adding the correspondent quanties

Threaded View

Attila Toth Look up and adding the... 01-21-2010, 02:02 PM
NBVC Re: Look up and adding the... 01-21-2010, 02:04 PM
Attila Toth Re: Look up and adding the... 01-21-2010, 02:16 PM
NBVC Re: Look up and adding the... 01-21-2010, 02:22 PM
Attila Toth Re: Look up and adding the... 01-21-2010, 02:37 PM
  1. #1
    Registered User
    Join Date
    01-21-2010
    Location
    Toronto, On
    MS-Off Ver
    Excel 2003
    Posts
    8

    Look up and adding the correspondent quanties

    Hi,

    I have a database in Excel 2003 with two columns, almost 11,000 rows
    one column with item codes, many in multiple cells, second column indicates quantity,
    Can somebody help me with what functions can I add the quantities for the items showing in multiple cells, and have only one row showing the result,
    Example:

    AC-BN-BAN01 16500
    AC-BN-BAN01 9000
    AC-BN-BAN01 12500
    AC-BN-BAN02 3
    AC-BN-BAN05 9
    AC-BN-BAN05 600
    AC-BN-BAN05 600

    I need to have only this info:
    AC-BN-BAN01 38000
    AC-BN-BAN02 3
    AC-BN-BAN05 1209
    etc

    Thank you
    A
    Last edited by NBVC; 01-21-2010 at 10:05 PM.

Thread Information

Users Browsing this Thread

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

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