Compare Two Lists

Compare a full roster with a submitted list.

Quick start

  1. Put the full roster in A and the list to check in B.
  2. Use an extra identifier to tell repeated names apart.
  3. Download the workbook with submission status added.

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.