How can I compare a list of strings, allowing positive matching b.
I'm interested in being able to compare strings, and returning a positive
match has been found (e.g. tree = trees). Just stripping of the last "s"
does not work when irregular plurals are included (e.g. consider geese and
goose, matches and match). I'm interested in a function similar to VLOOKUP,
but with this added functionality.
Is there a way of consulting a complete list of plurals, contained in a
library, or something similar? The English language can be a bit of a bitch
sometimes.
Has anyone ever encountered anything similar??
I'm using MS EXCEL 2003 (PC), if that helps.
Many thaks in advance.
|