Good to hear.

Thanks, Gord


On Fri, 29 Jan 2010 18:44:30 -0600, "Doug Mc"
wrote:

Thanks Gord,
That did the trick.

I appeciate your help.
Doug


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
You don't need a Criteria Range.

Just enter the List Range of $b$4:$b$3196

Leave Criteria Range blank.

The sole Criterion is "unique records"


Gord

On Fri, 29 Jan 2010 11:54:55 -0600, "Doug Mc"
wrote:

Thanks Gord,
I'm still have a problem:
My objective is that I want to eliminate records with consective last
names.
Last Name is in column B.

I click on Data, Filter, Advanced Filter and enter:
1. $b$4:$b$3196
2. $b$4:$b$3196
(The last name is n column B, the first record is number 4. The last
record
is number 3196)

I still get records with duplicate Last Names..

Will you please straighten me out?
Thanks again,
Doug



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
DataFilterAdvanced Filter.

Check "Unique records" and copy to another location.


Gord Dibben MS Excel MVP

On Thu, 28 Jan 2010 14:03:40 -0600, "Doug Mc"
wrote:

Is there some way to delete rows that have duplicate data in one column.
For instance, I have an address list including the whole family.
I would like to delete suceeding rows and leave the first one in that
family.

Thanks,
Doug