How to find and delete duplicate cells

[WhoRay]

Hi everyone!

I often work with data downloads that include duplicate values in multiple
rows (records). Is there a quick way to identify and delete the duplicates
and keep only one instance of the value. I need to perform VLookups with
the data and VLookup won't accept duplicate values. The lists are often
5000+ records and duplicates are hard to spot even when when doing a sort
and calulation of the difference between the values. Example is a list of
account #s and names:

0-123-4567-891-234 John Doe
0-321-4567-891-234 Mary Smith
0-123-4567-891-234 John Doe
0-234-5678-912-345 David Green

 

[Peo Sjoblom]

You can import the downloads to one sheet, copy over to another sheet using
advanced filter
Assume you import the stuff into Sheet1, use headers, in Sheet2 do
data>advanced filter,
select copy to another location and unique records only, in the List range
put the total imported
table with headers and all, for example

Sheet1!$A$1:$D$6000

in the copy to box put Sheet2!$A$1

click OK. Now you can run vlookup on the new table

 

[WhoRay]

Peo:

Sorry it took so long to respond to your suggestion. I am new to newsgroups
and I had trouble finding my way back.

Do you get tired of hearing how great your suggestions are? Well sorry, if
you do. You suggestion was great!! Thanks for saving me hours of time.

WhoRay

 

[Peo Sjoblom]

My Pleasure..

--

Regards,

Peo Sjoblom

Peo:

Sorry it took so long to respond to your suggestion. I am new to newsgroups
and I had trouble finding my way back.

Do you get tired of hearing how great your suggestions are? Well sorry, if
you do. You suggestion was great!! Thanks for saving me hours of time.

WhoRay


list