Dataset compare
Google Sheets: Dataset compare
Categories:
Find the intersection of the two different colums dataset
=FILTER(A:A, COUNTIF(B:B, A:A))
| A | B | Intersection of column A & B |
|---|---|---|
| aaa | ccc | ccc |
| bbb | eee | eee |
| ccc | ggg | |
| ddd | ||
| eee | ||
| fff |
Find the difference set of the two different colums dataset
=FILTER(A:A, ISNA(MATCH(A:A, B:B, 0)))
| A | B | Intersection of column A & B |
|---|---|---|
| aaa | ccc | aaa |
| bbb | eee | bbb |
| ccc | ggg | ddd |
| ddd | fff | |
| eee | ||
| fff |
Reference
- FILTER function - Google Docs Editors Help
- ISNA - Google Docs Editors Help
- MATCH function - Google Docs Editors Help
- COUNTIF - Google Docs Editors Help