 |
 | 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 / New Users / November 2007Compare two lists of names
Hello, I have a list of names in column A (a subset of the names on list B) and a list of names in column B (the entire list of names). Is there some way to compare the two lists and highlight, copy elsewhere, or somehow flag the names that are in list A but not in list B. Thanks BAM See http://cpearson.com/excel/duplicates.aspx > Hello, I have a list of names in column A (a subset of the names on list B) > and a list of names in column B (the entire list of names). Is there some [quoted text clipped - 4 lines] > > BAM > Hello, I have a list of names in column A (a subset of the names on > list B) and a list of names in column B (the entire list of names). Is [quoted text clipped - 4 lines] > > BAM Are you talking about two worksheets? If so, with both open, try the Compare side by side function under the Window menu. http://office.microsoft.com/training/training.aspx?AssetID=RP011212121033&CTT=6& Origin=RP011212401033 Not sure whether this allows editing but see tutorial in link above. Thanks very much, BAM >> Hello, I have a list of names in column A (a subset of the names on list >> B) and a list of names in column B (the entire list of names). Is there [quoted text clipped - 12 lines] > > Not sure whether this allows editing but see tutorial in link above.
|
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
|
©2008 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.