The pwrSIMILARITY PowerUp function returns a percentage rating of the comparison of two strings in Excel. This comparison can either be case sensitive (the default) or case insensitive.
pwrSIMILARITY(value1, value2, ignorecase, sensitivity)
The pwrSIMILARITY PowerUp function has the following arguments:
value1 – Required. This one of the text strings to be compared.
value2 – Required. This is the other text string to compare.
ignorecase – Optional. The default value is FALSE, meaning the function will consider letters of different case to not match.
sensitivity – Optional. Specifies the degree of sensitivity in the text comparison. The values range from 2 thru 6. Use a higher value for larger blocks of text. The default value is 3.
pwrSIMILARITY will return the percentage match between the two strings provided.
The default comparison is case sensitive.
Increase the value of the sensitivity parameter when comparing large blocks of text. For shorter strings, consider using the lower sensitivity threshold of 2.
=pwrSIMILARITY("The Excel Text Analyzer add-in is awesome!!", "The Excel Text Analyzer add-in rocks!")
Will return a percentage value (between 0 and 1.0).
=pwrSIMILARITY("The Excel Text Analyzer add-in is awesome!!", "THE EXCEL TEXT ANALYZER ADD-IN ROCKS!", TRUE, 4)
Will do a case-insensitive comparison, with a higher sensitivity threshold – meaning the strings must be an even closer match to score higher. The return value will be a percentage score.