Hello everyone!
Big conundrum here. I've got about 50000 rows and 10 columns of data. In one column (column J), I have a bunch of values that I want to reduce down to just unique values, but I want to delete the entire row for duplicates in this column, and do it with a macro! Problem is, I am running into HUGE inefficiencies with my current code, code inspired by certain suggestions I've found throughout the internet. Here's what I'm trying to do currently:
To explain further, I would like something like this:
A B C ... J
1 2 3 VAVA
4 5 6 VAVB
1 8 9 VAVA
1 2 3 VAVC
1 4 4 VAVB
1 4 4 VAVC
to go to this:
A B C ... J
1 2 3 VAVA
4 5 6 VAVB
1 2 3 VAVC
Just keeping the unique values in column J and deleting entire rows for duplicates
I got the dictionary idea and variations on the for loop idea from stackoverflow, but these methods are EXTREMELY slow and inefficient when working with 50,000 rows of data. I swear there has to be a way to implement built in "removeduplicate" functionality with VBA. Any ideas? Thanks everyone.
Bookmarks