See Chip Pearson's page on this

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

--
Regards,
Tom Ogilvy

"mm" wrote in message
...
I'm downloading information from a database and everything in one of the
fields is duplicated. I would like a formulate or filter to eliminate the
duplicate.