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/

.