![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
duplicate entries |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract duplicates in table | goran.c | Excel | 0 | 01-21-2015 12:47 AM |
![]() |
mnut | Excel Programming | 1 | 10-17-2014 10:05 PM |
Mail duplicates | mixy | Outlook | 0 | 02-10-2011 12:54 AM |
![]() |
JoJo | Outlook | 1 | 01-28-2011 04:39 PM |
![]() |
zxmax | Excel | 1 | 09-29-2006 08:29 PM |