software

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 www.contextures.com/xlDataVal01.htmlEric Wrote:
gt; In column A, I get a list of name, which name can be duplicated, such
gt; as
gt; John, Mary, John, Peter, Amy, Mary, Amy, Peter
gt;
gt; I would like to create a menu for listed names, which name cannot be
gt; duplicated, such as
gt; Amy, John, Mary, Peter
gt;
gt; Does anyone know how to do that in excel?
gt; Thank you in advance
gt; Eric--
tropezfn
------------------------------------------------------------------------
tropezfn's Profile: www.excelforum.com/member.php...oamp;userid=33351
View this thread: www.excelforum.com/showthread...hreadid=534399Thank you
Eric

quot;tropezfnquot; wrote:

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

Thank you
Eric

quot;tropezfnquot; wrote:

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