Remove Repeats in a Column

[Steve C]

I have a column of data and i would like to remove the repeats in the same
column or maybe with a helper column. See below:

Example:

ColumnA ColumnB

John Doe John Doe
John Doe
Kim Smith Kim Smith
Kim Smith
Kim Smith
Kim Smith
Dav Hodge Dav Hodge
Dave Hodge

Thanks.

 

[Paula]

Try this:

1) Make sure that the first row in the column has a column header.
2) On the Data menu, point to Filter, and then click Advanced Filter.
3) In the Advanced Filter dialog box, click Copy to another location.
4) If the column (or range) that you are evaluating is not already selected,
delete any information in the List range box and then click the column (or
select the range) that contains your data.
5) In the Copy to box, delete any information in the box or click in the
box, and then click a blank column where you want to copy the unique values.
6) Select the Unique records only check box, and click OK.
7) The unique values from the selected range are copied to the new column.

Then you can delete the first column and keep only the column with the
unique names.

Paula

 

[Steve C]

Thanks. This was helpful. is there a way to accomplish this without runing
the macro?

 

[Steve C]

Thanks Paula, i'm familiar with the unique records function. I'm looking to
replace the repeats in the column with a blank space to maintain the current
cell positions. Is there a formula that can do that? Thanks!