Hello,
on Sheet I am using this formula to compare 2 strings and show similarity in %:
=(MAX(LEN(A8); LEN(B8)) - levenshtein(A8;B8))/MAX(LEN(A8); LEN(B8))
When I use this code in Macro I receive an error:
"Sub or Function not defined" for MAX.
What is the problem,
thanks
on Sheet I am using this formula to compare 2 strings and show similarity in %:
=(MAX(LEN(A8); LEN(B8)) - levenshtein(A8;B8))/MAX(LEN(A8); LEN(B8))
When I use this code in Macro I receive an error:
"Sub or Function not defined" for MAX.
What is the problem,
thanks