Hi, wonder if this is even doable
i want to match 2 fields, but there's no 100% matches in any of the entries. so what i need done is somehow to be able to compare all the letters (however many times they appear) to letters in the second field and then based on how many letters matched display a % matched
for example, if the 2 fields are
nata natalie
total number of letters is 11, 8 matched
so the % will be 8/11=72%
i couldve messed up, math is not my strength. but you get the idea? maybe there's a better way to calculate the %, i'd appreciate if anyone has suggestions
thank you
i want to match 2 fields, but there's no 100% matches in any of the entries. so what i need done is somehow to be able to compare all the letters (however many times they appear) to letters in the second field and then based on how many letters matched display a % matched
for example, if the 2 fields are
nata natalie
total number of letters is 11, 8 matched
so the % will be 8/11=72%
i couldve messed up, math is not my strength. but you get the idea? maybe there's a better way to calculate the %, i'd appreciate if anyone has suggestions
thank you