Comparing similar values in Excel

[Ritchiekev3003]

Hi,

I'm a fairly average Excel user but I'm trying to find out how to compare same and similar data in a worksheet to calculate their similarity as a fixed percentage.

For Example..... HROR11 and HROX11 are codes that represent a 75% similarity in terms of what they represent but does anybody know how I would get excel to recognise this and match accordingly??

Cheers

Kevin

 

[VoG]

Hello and welcome to MrExcel.

This should help http://www.mrexcel.com/forum/showthread.php?p=955137#974873