automatically compare the data in 2 sheets (data format could be different)

[lillude]

Hi,

Wanted to know if there is a way to programatically compare the 2 columns in different sheets. Format of data is little different in both the sheets. e.g.

column in SHEET A will have data as "Microsoft Office 2010" and column in SHEET B will have something like "Office 2010"


Is there a way to find out "Nearly match" instead of looking for the exact match.



Number of rows in the sheet is very high (90000+) .

Thanks in advance.

[JeffreyWeir]

Sure. But you really need to upload a sample worksheet so we can get a feel for what the data layout is, and how similar/disimilar the strings are.