Word similarity function in Excel

[lwick]

Hey, I'm looking for help with a word sorting function in excel. Basically the function should be able to analyze a tweet and compare it to another tweet and return the percent of matching words of the first tweet from the second.

The code should start with

Please Login or Register  to view this content.

and return TRUE for the boolean value if the first tweet has a 70% or greater similarity with the second following tweet and FALSE otherwise. It applies to a worksheet with over 500 values so I just want to be able to copy and the function down the whole sheet to match the similarity of a tweet with the following tweet. Let me know if you can offer any help, I'd appreciate it.

[walruseggman]

This looks like homework. You'll get better responses if you post your current code, ideas on how to approach the problem, specific concepts you're getting stuck on, etc.