Duplicate data

[Doug Mc]

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

 

[Gord Dibben]

Data>Filter>Advanced Filter.

Check "Unique records" and copy to another location.


Gord Dibben MS Excel MVP

 

[Doug Mc]

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]

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

 

[Doug Mc]

Thanks, I'll try that.

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

 

[Doug Mc]

Thanks Gord,
That did the trick.

I appeciate your help.
Doug

 

[Gord Dibben]

Good to hear.

Thanks, Gord

Thanks Gord,
That did the trick.

I appeciate your help.
Doug