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