 |
 | 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 / July 2006Comparing info
If I have a list of names (Last in one column, First in another) and fax numbers can excel compare and update or flag the numbers that changed or names who are not on the on the first list and also flag new names? Excel 2000 but could use 2003. Thanks, Linda Linda You say "compare". You also say you have "a list". What do you want Excel to compare this list to? Do you have another list? You also say "update". Do you have a master list and you want to update some other list from the master list? HTH Otto > If I have a list of names (Last in one column, First in another) and fax > numbers can excel compare and update or flag the numbers that changed or [quoted text clipped - 4 lines] > Thanks, > Linda Otto, Thanks for helping me organize my question a little better. Yes, I would have another list with the same fields. This is a list of physicians in the area. We have the infomation entered but know many physicians change fax numbers, move etc....I am hoping to find a service that updates this info monthly and hopefully they can send the list in excel. However, after typing this out and thinking about it, we should probably just replace the old list with the new one. HA! done...thanks a million! Linda > Linda > You say "compare". You also say you have "a list". What do you want [quoted text clipped - 9 lines] >> Thanks, >> Linda Hi Linda See http://www.cpearson.com/excel/duplicat.htm  SignatureRegards Ron de Bruin http://www.rondebruin.nl > If I have a list of names (Last in one column, First in another) and fax numbers can excel compare and update or flag the numbers > that changed or names who are not on the on the first list and also flag new names? [quoted text clipped - 3 lines] > Thanks, > Linda Thanks, Ron. After replying to the above response, I decided to replace my list with the new one but this article will come in very handy for some other things on my To Do pile. Linda > Hi Linda > [quoted text clipped - 9 lines] >> Thanks, >> Linda
|
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.