Hi,

I've been trying for several hours to delete duplicates from an Excel file
that has been exported from a database application. I have read many, many
posts, and none seem to work for me. I've tried conditional formatting to
highlight duplicates, Advanced Filtering (many times), and it just doesn't
seem to work. I am trying to remove duplicates based on e-mail addresses,
from a table of 4500 records. Can someone please tell me step-by-step what
to do: where to click, the terms that Excel uses etc?

Thanks,

Jane

I think Advanced filter should work for you.
Follow these steps-

1. Select the entire range, say A1:A4500, including column heading
2. Go to Data--Filter--Advanced filter
3. Select copy to another location
4. Tick the check box 'Unique Records only'
5. Specify the location where you want the unique records to be listed.

Remember step 4 and 5 are most important.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Jane" wrote:

Hi,

I've been trying for several hours to delete duplicates from an Excel file
that has been exported from a database application. I have read many, many
posts, and none seem to work for me. I've tried conditional formatting to
highlight duplicates, Advanced Filtering (many times), and it just doesn't
seem to work. I am trying to remove duplicates based on e-mail addresses,
from a table of 4500 records. Can someone please tell me step-by-step what
to do: where to click, the terms that Excel uses etc?

Thanks,

Jane

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

And be sure to check your data. If you have extra spaces (leading/trailing/or
embedded), the values won't be duplicates.

Jane wrote:

Hi,

I've been trying for several hours to delete duplicates from an Excel file
that has been exported from a database application. I have read many, many
posts, and none seem to work for me. I've tried conditional formatting to
highlight duplicates, Advanced Filtering (many times), and it just doesn't
seem to work. I am trying to remove duplicates based on e-mail addresses,
from a table of 4500 records. Can someone please tell me step-by-step what
to do: where to click, the terms that Excel uses etc?

Thanks,

Jane

--

Dave Peterson