Hello all!
I have an event that require card access to validate attendance.
The card scanner populates B2 and overwrites after every scan.
<tbody>
</tbody>
When there is an ID match after the scan, I would like "Y" added in the SCANNER column.
Note: multiple scans are possible.
I am completely stumped on how to make this work. Any ideas and help is appreciated.
I have an event that require card access to validate attendance.
The card scanner populates B2 and overwrites after every scan.
A | B | C | D | E | F |
1 | ID SCANNER | SCANNED | ID | NAME | |
2 | 9000 | 8000 | BURNO | ||
3 | Y | 9000 | JAMES | ||
4 | 5000 | ADAM |
<tbody>
</tbody>
When there is an ID match after the scan, I would like "Y" added in the SCANNER column.
Note: multiple scans are possible.
I am completely stumped on how to make this work. Any ideas and help is appreciated.