How do I remove duplicate fields in excel

[Ivan Laars]

Hello,
I have a database where I need to strip out any instances where the text
value of a cell is duplicated further down in the column. For instance, if
cell c3 = "I hate you" and cell c200 = "I hate you", I want the second
instance (and any others if there are more) to be deleted. Is there a simple
way to do this, or an established macro?

Thanks,
Ivan

[Tom Ogilvy]

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"Ivan Laars" <Ivan Laars@discussions.microsoft.com> wrote in message
news:10F58F91-9761-4B3D-A3D5-BE633FA78237@microsoft.com...
> Hello,
> I have a database where I need to strip out any instances where the text
> value of a cell is duplicated further down in the column. For instance, if
> cell c3 = "I hate you" and cell c200 = "I hate you", I want the second
> instance (and any others if there are more) to be deleted. Is there a
simple
> way to do this, or an established macro?
>
> Thanks,
> Ivan

[Ivan Laars]

Never mind, I figured it out. Using the advanced autofilter system I can
delete duplicate records based on similarities within a column of cells.

"Ivan Laars" wrote:

> Hello,
> I have a database where I need to strip out any instances where the text
> value of a cell is duplicated further down in the column. For instance, if
> cell c3 = "I hate you" and cell c200 = "I hate you", I want the second
> instance (and any others if there are more) to be deleted. Is there a simple
> way to do this, or an established macro?
>
> Thanks,
> Ivan