On 24 Feb, 05:22, "Tom Ogilvy" wrote:
And I don't see an earlier post on this topic from you - but I know I
replied to such a question - maybe it wasn't you.

Levenshtein Distance Algorithm for string matchinghttp://www.merriampark.com/ld.htm (vb code implementation)

--
Regards,
Tom Ogilvy

wrote in message

ps.com...



On Feb 19, 4:05 pm, Tom Ogilvy
wrote:
Why do you say no success. I answered your question with a good
reference to
code that will do it.

--
Regards,
Tom Ogilvy

" wrote:
On Feb 19, 11:38 am, Madhan wrote:
Hi, yes it is possible. You can do the following,
1. Find the number of characters in one cell and assume that it is
100%
2. Check character-by-character the exactness of characters in both
the
cells and count the match
3. Calculate % from the count of matched characters

" wrote:
I asked this question in a roundabout way last week with no
success.

Basically, is it possible to compare text of one cell to another
cell
to produce a % of correctness. It doesn't have to be exact as I am
only using it to set up a French revision spreadsheet.

I know it's a tricky one but any help would be great. Over to the
experts!

Thanks

Tony- Hide quoted text -

- Show quoted text -

Thanks Madhan,
To be honest I am not sure how to do this and wouldn't know where to
start (my Excel knowledge is very limited) - can you help?

Thanks
Tony- Hide quoted text -

- Show quoted text -

Hi Tom,
Was your reply meant for me...I don't see any posting from you

Regards
Tony- Hide quoted text -

- Show quoted text -


Perfect solution Tom,
I was able to implement it to my requirements.
Many thanks

Tony