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 / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Excel Sorting - Finding Duplicate Entries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roxanne - 16 Jan 2008 15:07 GMT
Hello,

I have two Excel Spreadsheet with client names.  But I want to find  the
duplicates and create one file.

Is this possible without having to go through all 900 names?

Thank you
Roxanne
Nigel - 16 Jan 2008 15:22 GMT
Bring the two lists into one worksheet, copy list from one to the end of the
other.  Then use Advanced filter, to copy the full list to another location
and turn on the 'unique records only' option

In xl2003 you will find advanced filter in the data menu, the list range is
ALL of your names list, leave criteria empty, click 'Copy to another
location' (has to be on same worksheet), choose a suitable (empty column),
click 'Unique records only' and press OK.

Note: this is case sensitive and of course spelling, and any spaces at even
ones you cannot see at the end of name will be treated uniquely.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Hello,
>
[quoted text clipped - 5 lines]
> Thank you
> Roxanne
 
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.