Spreadsheet: 785929d1656850862-comparing-lists-of-data-names-dont-match-2022-07-04-oeldere-ray1975-list
Sheet: list 2

Date/Time | Name | Surname | help to make list | [NAME] If result is 0, the data is not filled in list 2 | ID1 | Location | Quantity | Site_Origen | Maquina_Origen | Colective
26/05/2022 11:59:38 | [NAME],[NAME], |  |  |  | BC0000020515 | ES6794 | 1 | 626 | 1113 | 11132 |  | Hello,
26/05/2022 11:59:46 | Sanz Sanz,[NAME], |  |  |  | BC0000038444 | ES4343 | 1 | 626 | 1111 | 11145
26/05/2022 12:00:41 | Sanz Sanz,[NAME], |  |  |  | BC0000038444 | ES4343 | 1 | 626 | 1111 | 11145 |  | I need to compare data from 2 sheets (highlighted in blue) with the following challenges:
26/05/2022 12:01:29 | Sanz Sanz,[NAME], |  |  |  | BC0000038444 | ES4343 | 1 | 626 | 1111 | 11145
26/05/2022 12:02:30 | Sanz Sanz,[NAME], |  |  |  | BC0000038444 | ES4343 | 1 | 626 | 1111 | 11145 |  | 1. List 1 contains who got access to the room and list 2 who has paid.
26/05/2022 12:02:37 | HELENA | ABARCA |  |  | GI00049989 | ES2163 | 1 | 626 | 1111 | 11100 |  | 2. Who is on one list and not on the other one and vice-versa.
26/05/2022 12:03:08 | HELENA | ABARCA |  |  | GI00049989 | ES2163 | 1 | 626 | 1111 | 11100
26/05/2022 12:03:39 | HELENA | ABARCA |  |  | GI00049989 | ES2163 | 1 | 626 | 1111 | 11100 |  | 3. Name comes 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. [NAME] Leyen, middle names, etc.
26/05/2022 12:03:45 | HELENA | ABARCA |  |  | GI00049989 | ES2163 | 1 | 626 | 1111 | 11100
26/05/2022 12:04:04 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134 |  | 4. List 2 contains an ID number linked to each employee.
26/05/2022 [NAME] | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:04:38 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1112 | 11134 |  | Any help will be greatly appreciated.
26/05/2022 12:04:53 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:05:07 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1112 | 11134
26/05/2022 12:05:21 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:05:44 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1112 | 11134
26/05/2022 12:05:51 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:06:03 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1112 | 11134
26/05/2022 12:06:12 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:06:15 | ANA | [NAME] |  |  | GI00499602 | ES4247 | 1 | 626 | 1111 | 11134
26/05/2022 12:06:43 | SHEILA | ABREU |  |  | GI00252431 | ES4251 | 1 | 626 | 1112 | 11132
26/05/2022 12:06:55 | DR. FRANCISCO | AGUADO |  |  | GI00009085 | ES2160 | 1 | 626 | 1111 | 11100
26/05/2022 12:07:10 | DR. FRANCISCO | AGUADO |  |  | GI00009085 | ES2160 | 1 | 626 | 1111 | 11100
26/05/2022 12:07:26 | [NAME] | AGUILERA JUST |  |  | GI00481230 | ES2159 | 1 | 626 | 1111 | 11100
26/05/2022 12:07:34 | [NAME] | AGUILERA JUST |  |  | GI00481230 | ES2159 | 1 | 626 | 1111 | 11100
26/05/2022 12:07:45 | [NAME] | AGUILERA JUST |  |  | GI00481230 | ES2159 | 1 | 626 | 1111 | 11100
26/05/2022 12:09:06 | [NAME] | AGUILERA JUST |  |  | GI00481230 | ES2159 | 1 | 626 | 1111 | 11100
26/05/2022 12:09:19 | EDWIN JESUS | AGUILERA TORRES |  |  | GI00244796 | ES6794 | 1 | 626 | 1111 | 11100
26/05/2022 12:09:23 | EDWIN JESUS | AGUILERA TORRES |  |  | GI00244796 | ES6794 | 1 | 626 | 1111 | 11100
26/05/2022 12:09:30 | JORDI | ALBA PEINADO |  |  | GI00091600 | ES6794 | 1 | 626 | 1112 | 11100
26/05/2022 [NAME] | ELISABETH | ALCAIDE |  |  | GI00060279 | ES4860 | 1 | 626 | 1112 | 11100
26/05/2022 12:09:53 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:10:08 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:10:23 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 [NAME] | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:11:22 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:11:35 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:11:47 | ELISABETH | ALCAIDE |  |  | GI00060279 | ES4860 | 1 | 626 | 1112 | 11100
26/05/2022 12:11:53 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:12:08 | ELISABETH | ALCAIDE |  |  | GI00060279 | ES4860 | 1 | 626 | 1112 | 11100
26/05/2022 12:12:10 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1112 | 11100
26/05/2022 12:12:16 | ELISABETH | ALCAIDE |  |  | GI00060279 | ES4860 | 1 | 626 | 1112 | 11100
26/05/2022 12:12:44 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:12:45 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:12:52 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:12:59 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:13:09 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:13:18 | [NAME] | ALCAIDE |  |  | GI00288755 | ES4342 | 1 | 626 | 1111 | 11100
26/05/2022 12:13:21 | ELISABETH | ALCAIDE |  |  | GI00060279 | ES4860 | 1 | 626 | 1112 | 11100
26/05/2022 12:13:31 | MONTSERRAT | ALCARAZ |  |  | GI00045239 | ES2158 | 1 | 626 | 1112 | 11100
26/05/2022 12:13:37 | MARIA-ELENA | ALHAJA |  |  | GI00086151 | ES2191 | 1 | 626 | 1111 | 11100
26/05/2022 12:13:50 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:14:21 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:15:07 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:15:13 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:16:42 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:17:27 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:17:46 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100
26/05/2022 12:18:01 | DR. JAVIER | ALMAGRO |  |  | GI00009485 | ES4251 | 1 | 626 | 1111 | 11100