Microsoft Office Forums - View Single Post - [Solved] Removing duplicates

Thread: [Solved] Removing duplicates

View Single Post

Old

05-24-2015, 11:47 PM

saurabhlotankar saurabhlotankar is offline

saurabhlotankar is offline

saurabhlotankar uses Windows XP

Windows XP saurabhlotankar uses Office 2010 32bit

saurabhlotankar uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: May 2015

Posts: 29

saurabhlotankar is on a distinguished road

Default

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)

Reply With Quote