Duplicate Records

[Kristy]

I am not real proficient in Excel but received a large (18,000+) file
from Data Processing in Excel to use for a mailing. My question is, I
need to find duplicate addresses and delete those before I do the
mailing. I work for the school district, so many families have more
than one child in the district and they only need to receive one
letter. Is there a way to do this?

Thanks,

Kristy

 

[Guest]

I'm not one of the experts here, but I've had the same situation. This is
what I did...

First, sort your sheet by address. Then in a column to the right of the
address enter this formula (assuming A2 is first address):

=IF(A2=A1,0,A2)
paste down the entire length...
then resort by column B
delete your zeros (0)

That should help...

 

[oldchippy]

I am not real proficient in Excel but received a large (18,000+) fil
from Data Processing in Excel to use for a mailing. My question is,
need to find duplicate addresses and delete those before I do th
mailing. I work for the school district, so many families have mor
than one child in the district and they only need to receive on
letter. Is there a way to do this?

Thanks,

Kristy

Hi Kirsty,

Have a look at Data > Filter > Auto filter, this may help

oldchippy :

 

[Guest]

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

Incidently, this is exactly the answer I gave to a posting several days
ago. You can often find answers to your questions by searching in the forum
-- also easy as pie: Just type a key word like "duplicates" in the search box
above.