LinkBack URL
About LinkBacks
Hi,
I have been unable to find the code that removes the rows with duplicate information in 3 columns that will work with excel 2003.
I have attached an example with the second sheet showing results required.
Any help appreciated.
Thanks,
David
Hi,
I have been unable to find the code that removes the rows with duplicate information in 3 columns that will work with excel 2003.
I have attached an example with the second sheet showing results required.
Any help appreciated.
Thanks,
David
i'm not sure about 2003... but this seems to be working in 2010...
hope it helps...
Please Login or Register to view this content.
(assuming the three columns you're wanting to check are E, F and G... if that is incorrect it's an easy fix.)
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Please let us know the columns which needs to be considered for duplicate check
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thats perfect Thanks
Sorry Sixthsense for not making that clear, it was columns E, F and G
The VBA provided by simarui worked great.
Glad you got the solution and thanks for the briefOriginally Posted by djfscouse
Upon further testing I just found out that it delete all rows if duplicates in column E are found which is not what I wanted, only delete rows that columns E, F and G are duplicated.
Could anybody look at this for me.
Maybe I should open a new post, please advise if so?
I have got the same output by using Excel's remove duplicates function. I know this function a bit corky. Just select columns E,F and G.
my bad,
my code is not actually checking the same row in which the duplicate E value is found, so basically if E F and G are all found somewhere else in the dataset (not necessarily on the same row...) then the row is deleted... that really isn't what you're looking for, and to do so would require a loop through a findall function which i've used a few times (found here http://www.cpearson.com/excel/findall.aspx)
but, much more simply, AB33 is correct. if you want that in vba for some reason this oughta work:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks