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.
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.
Bookmarks