How to create menu for listed names?

In column A, I get a list of name, which name can be duplicated, such as
John, Mary, John, Peter, Amy, Mary, Amy, Peter

I would like to create a menu for listed names, which name cannot be
duplicated, such as
Amy, John, Mary, Peter

Does anyone know how to do that in excel?
Thank you in advance
Eric

Eric can use Validation tool to do this. so that you only need to select the name you wants. see http://www.contextures.com/xlDataVal01.html

Originally Posted by Eric

In column A, I get a list of name, which name can be duplicated, such as
John, Mary, John, Peter, Amy, Mary, Amy, Peter

I would like to create a menu for listed names, which name cannot be
duplicated, such as
Amy, John, Mary, Peter

Does anyone know how to do that in excel?
Thank you in advance
Eric

Thank you
Eric

"tropezfn" wrote:

>
> Eric can use Validation tool to do this. so that you only need to select
> the name you wants. see http://www.contextures.com/xlDataVal01.html
>
>
> Eric Wrote:
> > In column A, I get a list of name, which name can be duplicated, such
> > as
> > John, Mary, John, Peter, Amy, Mary, Amy, Peter
> >
> > I would like to create a menu for listed names, which name cannot be
> > duplicated, such as
> > Amy, John, Mary, Peter
> >
> > Does anyone know how to do that in excel?
> > Thank you in advance
> > Eric
>
>
> --
> tropezfn
> ------------------------------------------------------------------------
> tropezfn's Profile: http://www.excelforum.com/member.php...o&userid=33351
> View this thread: http://www.excelforum.com/showthread...hreadid=534399
>
>

Thank you
Eric

"tropezfn" wrote:

>
> Eric can use Validation tool to do this. so that you only need to select
> the name you wants. see http://www.contextures.com/xlDataVal01.html
>
>
> Eric Wrote:
> > In column A, I get a list of name, which name can be duplicated, such
> > as
> > John, Mary, John, Peter, Amy, Mary, Amy, Peter
> >
> > I would like to create a menu for listed names, which name cannot be
> > duplicated, such as
> > Amy, John, Mary, Peter
> >
> > Does anyone know how to do that in excel?
> > Thank you in advance
> > Eric
>
>
> --
> tropezfn
> ------------------------------------------------------------------------
> tropezfn's Profile: http://www.excelforum.com/member.php...o&userid=33351
> View this thread: http://www.excelforum.com/showthread...hreadid=534399
>
>