LinkBack URL
About LinkBacks
I need to remove duplicate from two columns with a vba any ideas?
Capture.JPG
So bacically as you can see i want both colums to only have unique values
I have tried
but it did not work
Please Login or Register to view this content.
I need to remove duplicate from two columns with a vba any ideas?
Capture.JPG
So bacically as you can see i want both colums to only have unique values
I have tried
but it did not workPlease Login or Register to view this content.
Last edited by shelim481; 02-20-2020 at 11:31 AM.
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Hi
that code will treat the 2 column values as "pairs" and will only remove a "repeated-pair"
..so what you are asking for is a loop that will remove any duplicate found in the 'selected' or 'specified' range-block.
zeddy
Hi
Bernie's code will remove any cell in column B that is already in column A
..but it won't remove any duplicates that already exist in column A
zeddy
If there is duplicated in column A this does not work as intended, any solutions, i think it was my mistake i showed the wrong numbers
edit: add second check for duplicates in col. APlease Login or Register to view this content.
Last edited by KOKOSEK; 02-20-2020 at 11:37 AM.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
..maybe just add this line to Bernie's code..
zeddyPlease Login or Register to view this content.
Cool thank you all, much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks