De-Duping an email list

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 can delete them all.
then resort back to your original order, if needed.

http://www.rondebruin.nl/delete.htm

try the Ron tips

regards
Marcelo

"bob sacco" escreveu:

> 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!
>
>
>

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Rows.


Gord Dibben MS Excel MVP

On Mon, 14 Aug 2006 12:17:22 -0700, "bob sacco" <[email protected]> wrote:

>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!
>