Comparing a list with names that not match

Occasional Contributor


I need to compare data from 2 sheets (highlighted in blue) with the following challenges:

  1. List 1 contains who got access to the room and list 2 who has paid.
  2. Who is on one list and not on the other one and vice-versa?
  3. The names come in different formats. That should be relatively easy with the Text to Column function, although many names do not follow the standard 'name-surname' format. ie. Ursula von der Leyen, middle names, etc.
  4. List 2 contains an ID number linked to each employee.

Any help will be greatly appreciated.

0 Replies