Duplicate data
 

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

Duplicate data
 

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

Duplicate data
 

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

Duplicate data
 

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

Duplicate data
 

Thanks, I'll try that.




"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

Duplicate data
 

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

Duplicate data
 

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