Comparing Two Strings using Macro in Excel

[[email protected]]

I have no. strings like name of students in a Column A. Now I want to check duplicate names in list.

e.g.
Column A
SURESH GUPTA
ADITYA KULKARNI
PAYAL SINGH
GUPTA SURESH
SINGH PAYAL

I want output as below:

Column A Column B
SURESH GUPTA Duplicate ( Because it is duplicate with "GUPTA SURESH" in the list )
ADITYA KULKARNI
PAYAL SINGH Duplicate ( Because it is duplicate with "SINGH PAYAL" in the list )
GUPTA SURESH
SINGH PAYAL

Thanks in advance.

Govind

[amit.wilson]

Hello Govind,

welcome to the forum. If you are willing to use a helper column, then you won't need a macro.

See attached. The helper column B turns the two-name string into a single word with no space after sorting the two names are in alphabetical order. And then checks for duplicates

Cheers