Some obvious thoughts a
1. how accurate does the result need to be? And what is the risk if you
get it wrong?

2. I think getting a straight Dup or non-dup is going to be pretty
difficult first time. What you can get is an indication on a scale

3. metrics going into the scale could be:
- same number of words
- same exact word
- number of words that occur in both (this differs from the previous in
matching multiple occurances of one word in the first phrase to one or
more occurances in the second phrase)
- same words in the same order

4. you may find you want to remove certain words (eg the a etc)
5. or want to group words into phrases

your thoughts on this would help in finding an answer


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=534090