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

How to create menu for listed names?
 

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

How to create menu for listed names?
 

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

How to create menu for listed names?
 

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