You check who has not submitted by comparing two lists line by line
Compare a full roster with a submitted list. See who is missing, who needs a closer look, and download the original roster with every column preserved.
How to use it
- Paste the full roster (such as event registrations) into List A.
- Paste the list to check (such as payments received) into List B.
- Load the lists, review the matches and rows that need attention, then download the full roster with a status column. People found only in List B are kept on a second sheet.
- If names repeat, select another identifier such as class, student ID, or the last four digits of a phone number.
How to find people missing from a list
When you compare 40 event registrations with 37 payments by eye, it is easy to miss someone. Spreadsheet formulas such as VLOOKUP or COUNTIF can help, but a typo or a misused absolute reference can break the result. Formulas also cannot tell that two differently spelled names belong to the same person.
Names alone cannot distinguish people who share a name. Choose another identifier, such as a phone number, class, or ID, when you need it.
A missing phone number or duplicate row on either list can affect the result. Before comparing, check for names that appear more than once.
What this helps with
- Drawing lines between two printed lists by eye → Paste both lists and split the results into three groups.
- VLOOKUP and COUNTIF require formulas and careful references → Compare lists by pasting, with no formulas to write.
- Power Query is useful for larger repeatable workflows → This tool focuses on a quick roster comparison.
Limitations
- People with the same name cannot be distinguished by name alone. Select another identifier such as a phone number, class, or ID.
- A spelling difference on only one list appears as a separate entry. Review similar names in the results.
- Extra spaces are cleaned up, but different spacing within a name is treated as a different value.