ABCDEF
1
This sheet shows how to see if any items from list B appear in list A
2
1. Put the "master" or historical list of domains or values (up to 10,000 items) you want to check AGAINST in column A.
3
2. Sort the master list in ascending order by selecting the whole list and click the A-Z sort button.
4
3. Paste the list of values that you want to check against that master Column-A list in column B
5
4. Column C should show where a match was found
6
5. Filter the list for match or no match using Data - Filter - Autofilter, and paste as values into a new sheet to count, save, etc.
7
8
Previously delivered domains or other "master list"Domains or other values you want to see if they are IN that list
9
No Match
10
No Match
11
No Match
12
No Match
13
No Match
14
No Match
15
No Match
16
No Match
17
No Match
18
No Match
19
No Match
20
No Match
21
No Match
22
No Match
23
No Match
24
No Match
25
No Match
26
No Match
27
No Match
28
No Match
29
No Match
30
No Match
31
No Match
32
No Match
33
No Match
34
No Match
35
No Match
36
No Match
37
No Match
38
No Match
39
No Match
40
No Match
41
No Match
42
No Match
43
No Match
44
No Match
45
No Match
46
No Match
47
No Match
48
No Match
49
No Match
50
No Match
51
No Match
52
No Match
53
No Match
54
No Match
55
No Match
56
No Match
57
No Match
58
No Match
59
No Match
60
No Match
61
No Match
62
No Match
63
No Match
64
No Match
65
No Match
66
No Match
67
No Match
68
No Match
69
No Match
70
No Match
71
No Match
72
No Match
73
No Match
74
No Match
75
No Match
76
No Match
77
No Match
78
No Match
79
No Match
80
No Match
81
No Match
82
No Match
83
No Match
84
No Match
85
No Match
86
No Match
87
No Match
88
No Match
89
No Match
90
No Match
91
No Match
92
No Match
93
No Match
94
No Match
95
No Match
96
No Match
97
No Match
98
No Match
99
No Match
100
No Match