Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-02-2015, 06:47 AM
gebobs gebobs is offline Searching for Dupes Windows 7 64bit Searching for Dupes Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

* Select the table of your data including headers, if any.
* Select Data>Remove Duplicates.
* If you have headers, check "My data has headers" and the headers will be displayed in the list (rather than just the column letters.
* Uncheck all but the columns you want to check for duplicates i.e. make sure just first and last name are checked.
* Press OK.
Reply With Quote
 

Tags
de-dupe



Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for Dupes Searching by Quotation Length cheech1981 Word 4 03-14-2013 08:23 AM
Searching for Dupes Searching A Database Two Ways skoz55 Excel 3 11-10-2011 01:01 AM
Searching for Dupes Searching for Word Documents jocaan Word 2 09-08-2011 11:48 AM
Searching for Dupes Searching hyperlinks PuddinPie Word 1 05-27-2011 02:02 AM
Searching for Dupes effective searching mar999 Office 1 05-04-2011 04:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft