Finding Duplicate values within a single column

I have a list of e-mail addresses. I want to find all the duplicates. I have
sorted the list but the list is extremly long.
I have not found an effective method for doing this. I want the result to
show me where those duplicates occur.
Can anyone help me?
Thank you

I just realized that I posted this to the wrong group. i apologize. I will
re-post.
Thank you
Ed

"Ed P" wrote:

> I have a list of e-mail addresses. I want to find all the duplicates. I have
> sorted the list but the list is extremly long.
> I have not found an effective method for doing this. I want the result to
> show me where those duplicates occur.
> Can anyone help me?
> Thank you

Hi

Select the column. Menu Data > Filter > Advanced filter, there's a "show
unique items only" checkbox.

It will not mark the duplicates, it will hide them, which I suspect may be
your goal. If not, or anyway, see Chip's page
http://www.cpearson.com/excel/duplicat.htm

HTH. Best wishes Harald

"Ed P" <EdP@discussions.microsoft.com> skrev i melding
news:A9357AF7-3DB8-458A-BE63-9117EF20BF6E@microsoft.com...
> I have a list of e-mail addresses. I want to find all the duplicates. I
have
> sorted the list but the list is extremly long.
> I have not found an effective method for doing this. I want the result to
> show me where those duplicates occur.
> Can anyone help me?
> Thank you