Hi
this is a little bit complicated as you have to define what is 'alike'
for you. You could try for example
=IF(ISNUMBER(SEARCH(B1,A1)),"B1 is in A1","no match")

--
Regards
Frank Kabel
Frankfurt, Germany

"LizJ" schrieb im Newsbeitrag
...
I want to compare one column of text data with another, but not all
of the
information is the same. I don't need to know whether the data is
exact, I
simply want to know if it is alike.

Eg.
A B
Green Apples Apples
Juicy Pears Tree

If any part of the two cells are the same, e.g. as Row 1 I want to be
able
to return a value. Is auto filtering the only way to do this.