How do I remove duplicate fields in excel
 

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

How do I remove duplicate fields in excel
 

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

--
Regards,
Tom Ogilvy


"Ivan Laars" <Ivan wrote in message
...
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

How do I remove duplicate fields in excel
 

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