sorting out duplicate data of slight variation

[carl]

hi.

in a school district volunteer effort, i have a need to
sort out rows of data which are duplicates of other rows
of data yet some fields contain different data.

picture this:
columns: first name, last name, address
rows contain data like below:
susan, smith, 1440 wallaby way
joe, smith, 1440 wallaby way
bart, smith, 200 kings court

i need to keep susan or joe but not both.

HELP!

 

[David McRitchie]

Hi Carl,

You can use a filter, but I expect your initial goal is to identify
them and chose one of them at the primary one to keep.
Chip Pearson has a rather complete collection of dealing
with duplicates.

http://www.cpearson.com/exce/topic.htm
look for duplicates

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates