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.