How to compare names and remove similar ones in Excel?

You don't mention in what Excel version, but if you used Excel 2007, it would be easy to remove such duplicate data.

1.Click on any cell in the database.

2.Click the Design tab on the Ribbon.

3.Click on the Remove Duplicates option.

4.Doing so will select all the data in the database and open the Remove Duplicates dialog box.

5.When the dialog box opens, all of the column headings are selected by default.

To remove only those records from the database that match another record exactly:

1.Leave all column headings selected and Click OK.

To remove records from the database that have duplicate data in only one or more columns:

1.Remove the check marks from those columns you do not want to compare.

2.Click OK

Note: If you remove the wrong data, click the Undo button on the Quick Access toolbar or press CTRL + Z on the keyboard to get your data back.

For Excel 2003, this link might help solve your problem

http://www.cpearson.com/excel/Duplicates.aspx

Best of Luck.

I like: Em Isabelle Elle Anna Riley Zoe Annebelle