I have several columns of information (i.e addresses) and one of the columns
has duplicate numbers. I want to remove the duplicates rows and retain the
other columns. I tried to do the Advanced filter but could specify which
column I needed duplicates to be searched. Any help is appreciated.

What do you mean by "remove duplicate rows but retain the other columns"?

You want to remove duplicate rows in just one column without removing the
rows in other columns?

You would have to move that column to another sheet in order to do that then
use.......................

DataFilterAdvanced Filter.

Click on Unique Records only and either filter in place or copy to another
location.

If you want to remove all rows with duplicates in a particular
column..........

DataFilterAdvanced Filter.

From the List Range Refedit box select just a column, say column C

Click on Unique Records only and either filter in place or copy to another
location.


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 09:40:01 -0700, DC wrote:

I have several columns of information (i.e addresses) and one of the columns
has duplicate numbers. I want to remove the duplicates rows and retain the
other columns. I tried to do the Advanced filter but could specify which
column I needed duplicates to be searched. Any help is appreciated.

Thanks for the response. Example: I have two rows with the mostly the same
information and I want to remove one of them. One of the columns is the
field I want to search on where the duplicate occurs. Of course, I have
several hundred rows with the same situation. So...if I have 200 rows and
all are duplicated twice, I want to get just the list of 100 rows.

EX: (I want to be able to sort on column C, phone#, and remove all rows
with that duplicate.)

Joe 123 Main Street 555-1212
Joe 123 Main Street 555-1212

Thanks,

"Gord Dibben" wrote:

What do you mean by "remove duplicate rows but retain the other columns"?

You want to remove duplicate rows in just one column without removing the
rows in other columns?

You would have to move that column to another sheet in order to do that then
use.......................

DataFilterAdvanced Filter.

Click on Unique Records only and either filter in place or copy to another
location.

If you want to remove all rows with duplicates in a particular
column..........

DataFilterAdvanced Filter.

From the List Range Refedit box select just a column, say column C

Click on Unique Records only and either filter in place or copy to another
location.


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 09:40:01 -0700, DC wrote:

I have several columns of information (i.e addresses) and one of the columns
has duplicate numbers. I want to remove the duplicates rows and retain the
other columns. I tried to do the Advanced filter but could specify which
column I needed duplicates to be searched. Any help is appreciated.

Then use the advanced filter as second scenario below.

BTW............you don't have to sort first.


Gord

On Tue, 9 Jun 2009 11:19:01 -0700, DC wrote:

Thanks for the response. Example: I have two rows with the mostly the same
information and I want to remove one of them. One of the columns is the
field I want to search on where the duplicate occurs. Of course, I have
several hundred rows with the same situation. So...if I have 200 rows and
all are duplicated twice, I want to get just the list of 100 rows.

EX: (I want to be able to sort on column C, phone#, and remove all rows
with that duplicate.)

Joe 123 Main Street 555-1212
Joe 123 Main Street 555-1212

Thanks,

"Gord Dibben" wrote:

What do you mean by "remove duplicate rows but retain the other columns"?

You want to remove duplicate rows in just one column without removing the
rows in other columns?

You would have to move that column to another sheet in order to do that then
use.......................

DataFilterAdvanced Filter.

Click on Unique Records only and either filter in place or copy to another
location.

If you want to remove all rows with duplicates in a particular
column..........

DataFilterAdvanced Filter.

From the List Range Refedit box select just a column, say column C

Click on Unique Records only and either filter in place or copy to another
location.


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 09:40:01 -0700, DC wrote:

I have several columns of information (i.e addresses) and one of the columns
has duplicate numbers. I want to remove the duplicates rows and retain the
other columns. I tried to do the Advanced filter but could specify which
column I needed duplicates to be searched. Any help is appreciated.