Finding duplicates within a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is not a terribly difficult dilemma, but I need to know the easiest and
efficient way to deal with it.

I have one field full of email addresses. There are some duplicate records.
What's the best way to find the duplicate records in this field?

Thanks much in advance, for your time and feedback.

Jarrod
 
Nevermind I figured it out. Just pasted them to a list and sorted, then
deleted the dupes I found.

Jarrod
 
This is not a terribly difficult dilemma, but I need to know the easiest and
efficient way to deal with it.

I have one field full of email addresses. There are some duplicate records.
What's the best way to find the duplicate records in this field?
Click to expand...

Create a Query using the "Find Duplicates" query wizard.

John W. Vinson[MVP]
 
Nevermind I figured it out. Just pasted them to a list and sorted, then
deleted the dupes I found.
Click to expand...

<sigh>

Let the computer do the work. Creative laziness is a wonderful tool!
Your technique would be fine for 200 addresses... but would you really
want to try it with 20,000?

John W. Vinson[MVP]
 
Back
Top