Wrote up a quick Macro
What's this doing:
It's going to the 1st cell of your duplicates (In my case N2 and assuming of course that the ones you want to delete are on the right side). Selecting and cutting them.
Then, again, assuming that you have some extra data in L, it's going to the bottom of it, moving 1 more down and to the right and pasting in the previously cut data.
Performing the Remove Duplicates function.
Again, moving to L and 1 down/right
Selecting and cutting from there to the end and pasting it back into the 1st cell of the column that shouldn't have any dupes.
The reasoning for the L column is cause I have a "Top 60 Heroes" list and the #'s 1 thru 60 in L. So, basically it goes to L and then like I said, goes down then 1 more down and then takes a left to the open cell.
You could alter this if you don't have any data in the left most cell by changing the 1st one to
Cells(Rows.Count, "L").End(xlUp).Offset(1, 0).Select
That will just go down and down 1 more to the open cell.
And then replace the 2nd one with
Range("M62").Select
Where M62 is the 1st cell after the ones you wanted to keep.
I have a header on M1 so that's the reason for the 62 and not 61. And for some reason, my mind, when I see that I'm on row 61, immediately thinks that I have 61 heroes listed even tho I KNOW I only have 60. SO, I did the #'s to keep me centered.
I'm sure I've kinda explained this badly because what goes on in my head doesn't always translate to my fingers
Bookmarks