I keep up with attendance at my job. In column A, I have the entire roster of our employees, by last name only. In column B I copy and paste the names from the Swipe Report (which shows what employees were present that day). For privacy reasons I'm making up names instead of using their actual names. The spreadsheet looks like this:
Last Name Last Name, First Name
Arthur Arthur Clint
Beaumont Beaumont Jason
Johnson Johnson Derrick
Klein Klein Mitch
Larson Larson Silvia
Mathews Mathews Carl
Person Smith Terry
Smith
Basically what I'm trying to do is find out which name(s) in column A that aren't in column B. (In this example, obviously "Person" isn't listed in column B) but I have a huge list of names so it would take forever for me to go in and search individually. I've tried everything I've found on the internet and none of it has worked.
Bookmarks