Set Operations in Google Sheets -- by Marc Meyer

	A	B	C	D	E
1	set a	set B
2	1	0
3	2	3
4	3	5
5	4	6
6	5	8
7		10
8
9
10	A+B	A-B	B-A	A & B (intersection)	A+B (deduped)
11	1	1	0	3	1
12	2	2	6	5	2
13	3	4	8		3
14	4		10		4
15	5				5
16	0				0
17	3				6
18	5				8
19	6				10
20	8
21	10
22
23
24
25
26	Formulas
27	={setA;setB}	=filter(setA, iserror(MATCH(setA,setB,false)))	=filter(setB, iserror(MATCH(setB,setA,false)))	=iferror(filter(setA, MATCH(setA,setB,false)), "none")	={setA;filter(setB, iserror(MATCH(setB,setA,false)))}
28					setA + (setB - setA)
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100