Advanced Excel Filter Settings
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Copy & Paste in your Excelsheet with DNA Matches downloaded from AncestryDNA Helper
2
For more instructions follow this link:
3
How to find those elusive African DNA matches on Ancestry
4
5
6
1) Strictly "100% African" filter (leaves out all DNA Matches with any non-African regional score)
7
8
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
9
<>*Europe*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*
<>*Iberian*<>*Italy*<>*Europe*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*<>*Iberian*<>*Italy*<>*Asia*<>*Asia*<>*Native*<>*Native*
<>*Melanesia*
<>*Melanesia*
<>*Polynesia*
<>*Polynesia*
<>*Caucasus*
<>*Caucasus*
<>*Middle*<>*Middle*
10
11
12
2) More inclusive African filter (leaves in "mixed" Africans such as the Fula, Malagasy and North/East Africans)
13
14
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
15
<>*Europe*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*
<>*Iberian*<>*Italy*
<>*Europe West*
<>*Europe East*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*<>*Native*<>*Native*
16
17
18
3) Strictly Non-European filter (leaves out all DNA Matches with any European regional score)
19
20
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
21
<>*Europe*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*
<>*Iberian*<>*Italy*<>*Europe*
<>*Great Britain*
<>*Ireland*
<>*Scandinavia*
<>*Finland*<>*Iberian*<>*Italy*
22
23
24
4) Strictly European filter (leaves out all DNA Matches with any non-European regional score, except Africa North, Middle East and Caucasus)
25
26
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
27
<>*Asia*<>*Asia*<>*Native*<>*Native*
<>*Polynesia*
<>*Polynesia*
<>*Melanesia*
<>*Melanesia*
<>*Senegal*<>*Senegal*<>*Ghana*<>*Ghana*<>*Benin*<>*Benin*<>*Nigeria*<>*Nigeria*
<>*Cameroon*
<>*Cameroon*
<>*Bantu*<>*Bantu*<>*Hunter*<>*Hunter*<>*Mali*<>*Mali*
28
29
30
5) More inclusive European filter (leaves in trace regional amounts of minor African/Asian/Pacific admixture)
31
32
ethnicregions
ethnicregions
ethnictraceregions
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
33
<>*Asia*<>*Native*<>*Native*
<>*Polynesia*
<>*Melanesia*
<>*Senegal*<>*Ghana*<>*Benin*<>*Nigeria*
<>*Cameroon*
<>*Bantu*<>*Hunter*<>*Mali*
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
Loading...
 
 
 
Filter Settings 1
Filter Settings 2
Fula examples
Malagasy examples