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.
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
Comments
Be the first to comment.