If you are a daily user of Excel, you cannot afford not to install this wonderful plugin!
Office Powerups for Excel will allow you to perform dozens of actions that take long and tedious formulas in seconds. Furthermore, it will allow you to perform actions that until now you could not perform at all.
For example, "Fuzzy Find and Replace" will allow you to search for and replace approximate matches; ie “John Smith,” “Jonathan Smith,” and “John Smyth” can be approximate matches. Another useful tool allows you to perform a fuzzy VLOOKUP, which means it will find similar text to the text you are looking up. This is very useful to anyone using the VLOOKUP feature on tables without identical sources.
The “similarity” tool is great for performance testing of original text versus rewritten text, returning a percentage rating of the comparison of two strings. For example, if the result is .80 or above, you can estimate with a high degree of certainty that the rewritten text is mostly copied from the original text (not necessarily what you wanted). If it is .50 or less, you can assume that the text is of the same subject, but perhaps the authors of the texts are different.
Save yourself multiple macros and install free software that lets you perform actions even after the expiration of the trial period.