A way to eliminate repeated info within a cell
 

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.

A way to eliminate repeated info within a cell
 

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.

A way to eliminate repeated info within a cell
 

Try this it will find duplicates

Sort your data by the column with the duplicates in, insert a column
next to it and put something like this,

formula in B1

=IF(A1=A2,"duplicate","") and copied this down to the end - this says
if A1 is the same as A2 mark it as "duplicate" otherwise put "blank"

Alter cell ref to suit

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566446