Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-21-2015, 05:40 AM
saurabhlotankar saurabhlotankar is offline Removing duplicates Windows XP Removing duplicates Office 2010 32bit
Novice
Removing duplicates
 
Join Date: May 2015
Posts: 29
saurabhlotankar is on a distinguished road
Post Removing duplicates

Hi Folks,

I have an excel sheet. In column A, I have 200 names(Firstname Lastname format). I want to remove duplicates from this column. Now the challenge is somes firstname and last names gets interchanged(e.g. value in A3 is John Smith and value is A80 is Smith John). Ideally its the same person and hence i have to keep his name only once.

So can anyone please assist me in removing such interchanged names duplicates.



Thanks.
Reply With Quote
 

Tags
duplicate entries



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract duplicates in table goran.c Excel 0 01-21-2015 12:47 AM
Removing duplicates Adding duplicates as comments mnut Excel Programming 1 10-17-2014 10:05 PM
Mail duplicates mixy Outlook 0 02-10-2011 12:54 AM
Removing duplicates Inbox and subfolder duplicates JoJo Outlook 1 01-28-2011 04:39 PM
Removing duplicates sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


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