Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 15 Dec 2005 21:57 GMT
I have 2 list of phone numbers in 2 different workshhet.
How can I merge them in one list eliminating the repetitions
David McRitchie - 19 Dec 2005 01:21 GMT
You could paste one below the other, and sort on phone number.
I'd expect you would want to examine the duplicates, so would include
a sequence  number from top to bottom (constants) and include that
as your secondary sort field.

Then see Chip Pearson's page:(s) on Duplicates
   http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
others can be fround in his
  http://www.cpearson.com/excel/topic.htm
Signature

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I have 2 list of phone numbers in 2 different workshhet.
> How can I merge them in one list eliminating the repetitions
 
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.