 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2006How 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 selec 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, suc > as [quoted text clipped - 7 lines] > Thank you in advance > Eri 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 [quoted text clipped - 11 lines] > > Thank you in advance > > 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 [quoted text clipped - 11 lines] > > Thank you in advance > > Eric |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.