Hi,
I have a base list of ~4,000 customers and I want to compare that with a
shorter list that contains inaccurate customer names.
With accurate Customer names I would normally use the OFFSET($A$1,
MATCH(Value,Array,0),ColumnRequired) function combination. I was thinking of
using some LEFT(InaccurateName,1) iterative style of comparings first,
second, third...n, letters of the inaccurate customer names with my list to
get a % Match per string and then manually sort through them from here. eg
70% of letters (& order) match in a string = Review for manual match.
Any tips?
Thanks,
Ditch