Match Excel Columns containing names [Closed]

Report
-
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
-
Hello,

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?

1 reply

Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,493
Greetings,

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.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!