You check who has not submitted by comparing two lists line by line

Built!

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.

Current workflow

Most people place the two lists side by side and check names off one by one by eye. Even at a modest scale — say, 40 event applicants against 37 people who paid — one or two names almost always slip through. You can automate it in Excel with VLOOKUP or COUNTIF, but formula typos and absolute-reference ($) mistakes are common, and functions can't catch cases where the name itself was written differently. Heavier tools like Power Query take time to learn for this one small job, so many people end up back to comparing by eye.

Solution

Compare Two Lists

How to use

1. Paste the full list (for example, the applicant list) into A. 2. Paste the list to compare (for example, the payer list) into B. 3. The result comes out in three groups — only in A / only in B / in both. Check the rows that need review, then download the Excel file with the submission status added to the full list. Submitters missing from the full list stay on the second sheet. 4. If two people share the same name, add a distinguishing detail — class, number, or the last digits of a phone number — to tell them apart.

Example

- Input: an applicant list of 40 names (A) and a payer list of 37 names (B) - Result: three groups — applied but haven't paid / paid but never applied / in both lists. Leading and trailing spaces in names are trimmed automatically when you paste.

Open tool
View details
Limits
- People with identical names can't be told apart by name alone. Include a distinguishing detail (last digits of a phone number, class, or number). - Spaces are trimmed automatically, but names with different internal spacing are not treated as the same name.
Cost type
Free

Typos and duplicate names are the classic cases this tool can't resolve. If a name is misspelled in only one list (for example, "Kim Minsu" vs. "Kim Minshu"), the computer treats them as two different people and puts each in an "only in one list" group — you'll need to scan the results for similar-looking names yourself. If several people share the same name and neither list carries a distinguishing detail like a class, number, or phone digits, there's no basis to separate them at all. And if one list accidentally contains the same person twice, the result will be skewed, so removing duplicate rows before comparing gives a cleaner match.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in