Hello,
I need to compare data from 2 sheets (highlighted in blue) with the following challenges:
- List 1 contains who got access to the room and list 2 who has paid.
- Who is on one list and not on the other one and vice-versa?
- 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.
- List 2 contains an ID number linked to each employee.
Any help will be greatly appreciated.
