Hi,
I have a script where I input a list of values in column A of sheet1, then after I run the macro I want to have a unique list of the duplicate values on sheet2 in column A, however, the only thing listed is the header can someone tell me where I am going wrong?
Please Login or Register to view this content.
Last edited by sriley5; 06-09-2018 at 06:09 AM.
if you want this operation on sheet level then why not use the builtin function
Please Login or Register to view this content.
Teach me Excel VBA
Sounds like a good idea, however, I need a tool to report out the duplicates, the decision to remove them from the populated list is up to another person.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Bakerman2,
You're close, however, I need the opposite. The script you wrote gives me the unique values of the original list, I need a unique list of the values duplicated. - I will however keep your script in my back pocket since I'll need that for a future project.
Unique value which have duplicates.
Please Login or Register to view this content.
Something like this.
Please Login or Register to view this content.
Jindon,
I get a type mismatch error code
Bakerman2,Originally Posted by bakerman2
Something like this.
Please Login or Register to view this content.
This is amazing works perfectly and takes a split second to run. Appreciate it
Just strange, I've tested for myself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks