Take a look at Debra's site again.

It's more of a process than anything else.

Greg wrote:

Hi Dave,

I guess I'm being a "real dunce case" about this. Can you send me a sample
Excel Spreadsheet describing how to do this process using the data I posted
above? You can send the file to gamouning at yahoo.com.

With appreciation,
Greg

"Dave Peterson" wrote:

Then delete the original and keep the filtered list.


Greg wrote:

Hi Dave,

Thanks for your reply. I guess I am still not clear on what I want.
Filtering on unique records does eliminate duplicate e-mail addresses but
keeps a copy of the original. I want to eliminate the original and keep only
the non-duplicates.

Hope this is more clear.

-Greg

"Dave Peterson" wrote:

You could use data|filter|advanced filter (unique records only) and put the list
in a different location.

Then delete the original and keep the filtered list. Make sure you have a
header in your list.

Debra Dalgleish's instructions:
http://www.contextures.com/xladvfilter01.html#FilterUR

And Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm
--

Dave Peterson


--

Dave Peterson


--

Dave Peterson