De-Duping an email list

  • Thread starter Thread starter bob sacco
  • Start date Start date
B

bob sacco

I'm trying to remove duplicate email addresses from two seperate email
lists.

I figured out how to get the formula for finding the dups:
http://support.microsoft.com/kb/213367/en-us

But, now I'm trying to figure out how to remove the empty rows I have in my
long columns.

If I could find a formula or macro it would save me a TON of time because I
wouldn't have to go through 60000 rows and remove them manually...

THere MUST be an easier way!

help...Please!
 
if you sort by any column all the blanks will be together & you ca
delete them all.
then resort back to your original order, if needed
 
Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Rows.


Gord Dibben MS Excel MVP
 
Back
Top