Duplicate data

  • Thread starter Thread starter Doug Mc
  • Start date Start date
D

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
 
Data>Filter>Advanced Filter.

Check "Unique records" and copy to another location.


Gord Dibben MS Excel MVP
 
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
 
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
 
Thanks, I'll try that.




Gord Dibben said:
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
Click to expand...
 
Back
Top