How to Compare Three or More Lists in Excel
Comparing two lists is a solved problem. Comparing three is not — and the reason is arithmetic: two lists have three regions to keep straight, three lists have seven. Chaining pairwise COUNTIFs across seven regions is where the errors live, and they are invisible, because each individual formula is right.
Last updated: October 2026
| Value | Jan | Feb | Mar | In how many | Where |
|---|---|---|---|---|---|
| Ana | Yes | Yes | Yes | 3 | All lists |
| Ben | Yes | Yes | No | 2 | Some lists |
| Cara | Yes | No | No | 1 | Only Jan |
The 1-click way (Tellsheet)
Compare Many Lists
Put each list in its own column, select them all, and run Compare Many Lists. You get one row per distinct value, a tick for each list it is in, a count, and a Where column that says All lists, Only Jan or Some lists in plain words. Sort by count to put the values everyone shares at the top, or alphabetically to look something up. Case and surrounding spaces are ignored by default, and a value repeated inside one list counts once.
What the answer usually means
- Only the first list — leavers, cancellations, discontinued lines.
- Only the last list — joiners, new accounts, additions.
- All lists — the stable core, everyone who stayed the whole period.
- Some lists — the intermittent ones, which on a monthly comparison are the churn worth looking at.
Frequently asked questions
Why is three lists harder than two?
Seven regions instead of three; pairwise chaining misses some of them.
What is in all of them?
Sort by count — those sit at the top.
What is unique to one list?
The "Only <name>" rows.
Does case matter?
Not by default; you can turn it on.
Related Excel guides
Seven regions, one table
Compare Many Lists answers all of them at once — with a preview before anything is written.
Get Tellsheet free See pricing