- In short
- Compares two lists, which can be on different sheets, and shows what is only in the first list, only in the second, and in both. The result is written to a place you pick as three columns. Your source lists are not changed and you can undo. Three result columns at the picked cell. Your source data stays unchanged and can be reversed in one step with Undo Last.
What it is for
Compare Two Lists is used to compare two lists into only-in-first / only-in-second / in-both.
When to use it
It earns its place whenever you have to find the differences between two periods'/sources' lists.
Example scenarios
- Find the differences between two periods'/sources' lists.
What it needs
an options dialog + three picks (List1, List2, output); each list single-column; overlap refused, overwrite confirm. Supported data types: text, number, date (by selection).
How to use it
- Select the range to compare.
- Run Compare Two Lists from the Compare & Check group on the XLMind Plus tab.
- Tune the choices in the dialog before confirming.
- Confirm; three result columns at the picked cell.
What it produces
Three result columns at the picked cell.
Effect on your data and undo
Compare Two Lists does not change your source data; the result is added as a separate item. Undo Last rolls the change back in a single step.
How it differs from similar tools
No helper formulas are needed; the source area is read but never written, and the output is produced on its own.
Good to know
Overwrite confirmation. No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where is the output written?
- Three result columns at the picked cell.
- What happens to invalid or unexpected values?
- Text-safe.
- Does the result stay linked to the source?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- No special preconditions.
Works well with
- As a preparation step, try Extract Unique List
- To keep working on the result, use Compare Rows
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.