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.