joelle
05-01-2017, 12:31 PM
Dear Experts,
I guess there were similar posts as this but time is almost never on my side :)
so some quicky help is so much appreciated:
In the attached example, real life is that I have 100K rows, I need to find duplicate email, then remove both the entries, I mean, if I find a dup for anna@abc.com, remove the entire row and also the other row that contains anna@abc.com.
I know how to filter and remove dups, but it leaves me with 1 unique anna@abc.com, I want both gone.
So,
1. what is an plain excel way (like use filter to find dups, blah blah), or,
2. a simple VBA, but I do prefer the plain excel way.
Thank you so much!
joelle
I guess there were similar posts as this but time is almost never on my side :)
so some quicky help is so much appreciated:
In the attached example, real life is that I have 100K rows, I need to find duplicate email, then remove both the entries, I mean, if I find a dup for anna@abc.com, remove the entire row and also the other row that contains anna@abc.com.
I know how to filter and remove dups, but it leaves me with 1 unique anna@abc.com, I want both gone.
So,
1. what is an plain excel way (like use filter to find dups, blah blah), or,
2. a simple VBA, but I do prefer the plain excel way.
Thank you so much!
joelle