Purging Duplicat Records

  • Thread starter Thread starter Steve Emerick
  • Start date Start date
S

Steve Emerick

I have imported a list that has multiple contacts for each
location (e.g. three teachers at one school). For a
mailing all I need is one mailer to go to each location
and I don't want to print labels for every contact. How
can I find/delete the duplicates automatically without
scrolling through the document manually to find the
duplicates and then delete them? HELP!!!!
 
Use a help column next to the names,
in the first adjacent cell put

assume you inserted a new column A to the left of the old,
the old would now be B

=COUNTIF($B$2:B2,B2)

copy down as long as needed, select the whole table (names addresses etc)
do data>sort and sort by the help column in ascending order, this will
put all the 1 values at the top and thos values with 2 and over below,
now select the table below the 1s and delete them. Then delete the help
column and
you are done..
 
Back
Top