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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I de-dupe two columns of data in excel? 3
I need an Excel macro which will de-dupe a column of data? 1
Multiple column and row duplicate problem 2
Delete Dups 5
Creating a Unique List 5
De-concatenate? 2
Tricky Excel De-Dupe Problem 6
Creating an email list 2

Back
Top