How do I find who is absent from a roster?

Put the full roster in List A and the attendance or check-in list in List B. A only is everyone on the roster who is not on the present list.

What if someone checked in who is not on the roster?

Open B only—those names appear only on the present list. They may be walk-ins, typos, or people who should be added to the roster.

Find who is missing from the roster

Last updated: 2026-09-03

Paste the full class, team, or guest list into A and the signed-in or present names into B. After you compare, A only is everyone who should be there but did not check in.

Setup

List A — full roster (who should attend).
List B — check-in, sign-in, or “present” list.
A only — absences (on roster, not checked in).
B only — present names that are not on the roster.
Intersection — people who both belong and checked in.

Name tips

Use the same spelling on both sides (first + last, or student ID if you have it).
Leave Case off if exports mix “Alex Kim” and “alex kim”.
If the tool flags hidden characters from a spreadsheet paste, strip them before you trust absences.
This matches exact lines—it does not guess nicknames or swapped first/last names.

Example

A (roster): Alex Kim, Jordan Lee, Sam Patel, Taylor Ng
B (present): Jordan Lee, Sam Patel, Taylor Ng
A only: Alex Kim — marked absent.

Paste roster and attendance lists

Loading compare tool…

FAQ

How do I find who is absent?

Roster in A, present list in B, open A only.

Counts look wrong?

See why two lists don’t match.