How to create menu for listed names?

[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

 

[tropezfn]

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

 

[Eric]

Thank you
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

 

[Eric]

Thank you
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