YOUR EVERYDAY DATA DESK

Workspace.

Tools, formulas and worked examples worth keeping close.

Files stay in your browser0 saved on this browser

01 / DATA TOOL

Compare two lists

Find values in both lists or only one. Compare unique values without changing your original lists.

List A One value per lineList B One value per line

Trim edgesIgnore letter caseBlank lines are skipped. Repeated values count once.

2 only in A / 2 in both / 2 only in B1 repeated entries collapsed · Original order kept

#	Value	Found in
1	INV-1001	Only A
2	INV-1002	In both
3	INV-1003	Only A
4	INV-1004	In both
5	INV-1005	Only B
6	INV-1006	Only B

6 of 6 rows shown · Downloads include every row.

Prefix spreadsheet formula-like values with an apostrophe on exportChanges values starting with =, +, - or @, including negative numbers. Protection is not a guarantee; import untrusted files as text.

Understand the method and its limits20,000 records · 200 columns · 250,000 cells

FROM TASK TO CONFIDENCE

The tool is one part of the answer.

Keep the formula18 examples with inputs, results and caveats.Try it on safe dataSmall synthetic files with expected outcomes.

Data tools run locally. Saved items contain links only. Refreshing or leaving a tool can clear your working data. How your data is handled

Bookmark this workspace: Ctrl / ⌘ + D

Want to understand the spreadsheet behind the task? Learn step by step in Excel Academy ↗