Using Excel 2010 and I have 2 lists - 1 from phpmyadmin with a list of names entered by my users and a second list from my courier company that sends out my packages (they write the names all in caps and somethings they don't write the last letters from the names, e.g. Johns... instead of Johnson).
How can I compare the lists and see what names are in my phpmyadmin but the courier doesn't have?
Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.