finding duplicate addresses

[diamonds]

Hi to all,
I'm an Excel Virgin, well, Ok, I've went a little ways, but not all the way and I'm desperate.

I have about 18,000 entries on a mailing list. I've sorted by last name to find duplicate addresses (combined two lists) and it's tedious beyond belief.

Is there a way to take just the "address" column and search for duplicates without going through them one by one?

Please?
Help?
Quick?

Thanks!

[Dave]

Diamonds

Check out this link Chip Pearson's site. It should help you.

http://www.cpearson.com/excel/duplicat.htm

Dave

"diamonds" <[email protected]> wrote in
message news:[email protected]...
>
> Hi to all,
> I'm an Excel Virgin, well, Ok, I've went a little ways, but not all the
> way and I'm desperate.
>
> I have about 18,000 entries on a mailing list. I've sorted by last name
> to find duplicate addresses (combined two lists) and it's tedious beyond
> belief.
>
> Is there a way to take just the "address" column and search for
> duplicates without going through them one by one?
>
> Please?
> Help?
> Quick?
>
> Thanks!
>
>
> --
> diamonds
> ------------------------------------------------------------------------
> diamonds's Profile:
> http://www.excelforum.com/member.php...o&userid=35646
> View this thread: http://www.excelforum.com/showthread...hreadid=554302
>

[diamonds]

Thank you I will check that out !!