LinkBack URL
About LinkBacks
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"
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"
Last edited by Tasiast; 06-01-2013 at 01:17 PM.
See the small table starting at A60:
Gary's Student
Another option - vba code -
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello,
You just saved me alot of work. Very much appreciated.
Jakobshavn: Thank you sir. Unfortunately I had made my example too brief. I ended up sing the VBA.
Last edited by Tasiast; 05-27-2013 at 10:33 AM. Reason: Newbie trying to figure this out!
Which solution are you talking about ? You received 2 solutions.
arlu:
I like the approach!
Performing the two-way sort allows easy identification of which records must be removed.
Thank you Jakobshavn.
Hello,
I would like to tweak my post/request....
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks