Removing duplicates

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Removing duplicates

FAQ

Thread Tools

Display Modes

05-24-2015, 11:47 PM

saurabhlotankar saurabhlotankar is offline

Windows XP Removing duplicates

Office 2010 32bit

Novice

Join Date: May 2015

Posts: 29

saurabhlotankar is on a distinguished road

Hi,

I have attached an excel sheet. In column A you will find few names one below another. Few names are repeate and few names are repeated with interchnaged first and last names. e.g. A4= Ethan Anderson and A10= Anderson Ethan. I am facing challange here in removing such duplicate names.

Kindly assist.

Thanks,

Attached Files

Duplicates.xlsx (9.6 KB, 14 views)

Tags

duplicate entries

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract duplicates in table	goran.c	Excel	0	01-21-2015 12:47 AM
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
Inbox and subfolder duplicates	JoJo	Outlook	1	01-28-2011 04:39 PM
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 09:09 AM.