I have use the =if formula to do this.
In cell C1 enter =if(a1=b1,"Match","No match")
I use this usually to find out why data that is suppose to
match doesn't. In the above example using "" instead of
"Match" leaves the cell blank.
This works well when the cells are side by side or on the
same row. In your example you listed cells a1 and a2. In
this case i suppose you would have to put the =if formula
some where else. as to using it for a range of cells, You
would have to have a =if formula for each cell in the
range.

-----Original Message-----
Hi
there's no build-in function for this. so you have to
develop this kind of 'pobability match' on your own.

How do you define a match?
- specific number/percentage of characters are identical
- this first or the last part of the two strings are
identical
- ...


-----Original Message-----
I need a way to compare one cell to the adjacent cells
and/or a range of
cells... wherein the cells would not be exactly matched
strings of
text.

Example:

A1 - Bags of Apples
A2 - Bags of Oranges
-or-
A1 - C17 2004 Envelop
A2 - C19 2003 Envelopes

In these examples the formula would provide some
indicator of note,
like "Match" or something.

Is there anyway to do this with a function or macro?


---
Message posted from http://www.ExcelForum.com/

.

.