- In short
- Compares two adjacent columns row by row and writes Match/Different results into a new column. A new result column. Your source data stays unchanged; Undo Last brings it back if needed. The whole operation happens locally; nothing is sent anywhere.
What it is for
Compare Rows is used to compare two columns row-by-row into Match/Different/Blank.
When to use it
Typical use: compare expected vs actual values row-by-row.
Example scenarios
- Compare expected vs actual values row-by-row.
What it needs
Exactly 2 columns and an options dialog; whole-col A:B → used-data band. Supported data types: text, number, date (by selection).
How to use it
- Select the range to compare.
- Run Compare Rows from the Compare & Check group on the XLMind Plus tab.
- Pick the settings you need in the window that opens.
- Confirm; a new result column.
What it produces
A new result column.
Effect on your data and undo
Compare Rows does not change your source data; the result is added as a separate item. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
Two columns required.
Limitations
Two columns required.
Frequently asked questions
- Where will I see the result?
- A new result column.
- What happens to invalid or unexpected values?
- Text-safe.
- How are blank cells handled?
- Blank rows labeled.
- 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?
- Two columns required.
Works well with
- To tidy the data first, use Compare Two Lists
- To flatten a cross-tab into rows first, use Unpivot Columns
- To combine scattered sheets before summarizing, use Append Worksheets
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.