+ Reply to Thread
Results 1 to 2 of 2

Find highest revision number in one column of item number in another column and add total

  1. #1
    Registered User
    Join Date
    05-25-2013
    Location
    Mauritania
    MS-Off Ver
    Excel 2007
    Posts
    5

    Find highest revision number in one column of item number in another column and add total

    Hello,

    I am trying to find a way to find the highest revision (column 3) for each unique item number in column 9 and delete all the 'fluff".
    I am also looking to add total to 'POLI_QTY' that captures the totals of all the previous PO_SUPP quantities, while maintaining the deletion of of the oldest PO_SUPP revisions.
    For example, after the code is run, for S4540539, only PO_SUPP 4 is showing, but a total qty ordered of 81.3

    Thanks in advance

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: Find highest revision number in one column of item number in another column and add to

    I think you forgot to attach your workbook.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

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