Hello
Im having some trouble trying to remove duplicates.
I have attached a sample workbook. Basically, column J (invoice #) has duplicates, however I would like to remove the duplicate but keep the larger of the value from column M
i.e.
cell A1: invoice # 0300, column M = 8
cell A543: invoice # 0300, column M = 6
so I would prefer if A1 is selected.
Ive been stuck on this issue for some time and I'm not sure how to tackle the problem! can someone pls advise!
thx you
Last edited by step_one; 06-29-2011 at 07:24 PM.
step_one,
Give this a try:
Please Login or Register to view this content.
To add a macro to a workbook:
- Save a copy of the Excel workbook you want to modify
- Always test macros in a copy so that the original is preserved in case the modifications don't go smoothly
- Open the copy of the Excel workbook you want to modify
- Use the keyboard shortcut ALT+F11 to open the Visual Basic Editor
- Insert -> Module
- Copy/Paste the code into that area
To run a macro in a workbook:
- In Excel (not the Visual Basic Editor) press the keyboard shortcut ALT+F8
- Double-click the desired macro (I named this one RemoveDuplicatesMacro_for_step_one)
Hope that helps,
~tigeravatar
hey bud
thxs alot! it works flawlessly.
i verified by countif on the J, and i got no mutiple listing, so it appears to be working great. i really apprecaite your ingenius solution. again, thxs you so much!
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks