How to find and delete duplicate cells

  • Thread starter Thread starter WhoRay
  • Start date Start date
W

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
 
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
 
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
 
My Pleasure..

--

Regards,

Peo Sjoblom

WhoRay said:
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
Click to expand...
 
Back
Top