Comparing List

[aldiaz9000]

You have two list to compare...but they are not perfect...

For Example:

Black Blak
Inbev Inbevv

however your goal is to match these even though they are not perfect
Question: How do you do this?

Al

 

[Luke M]

Check out Chandoo's article on using a fuzzy search. Does almsot exactly what you describe:
http://chandoo.org/wp/2008/09/25/handling-spelling-mistakes-in-excel-fuzzy-search/

 

[aldiaz9000]

Check out Chandoo's article on using a fuzzy search. Does almsot exactly what you describe:
http://chandoo.org/wp/2008/09/25/handling-spelling-mistakes-in-excel-fuzzy-search/

thank I will look at this