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 DNAGedcom
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
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
9
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*<>*Asia*<>*Asia*<>*America*<>*America*<>*Melanesia*
<>*Melanesia*
<>*Polynesia*
<>*Polynesia*
<>*Caucasus*
<>*Caucasus*
<>*Near*<>*Near*
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
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
15
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*
<>*EuropeW*
<>*EuropeE*
<>*AngloSaxon*
<>*Celtic*<>*EuropeN*<>*Ural*<>*America*<>*America*
16
17
18
3) Strictly Non-European filter (leaves out all DNA Matches with any European regional score)
19
20
ethnicregions
ethnicregions
ethnicregions
ethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
21
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*
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*
<>*America*
<>*America*
<>*Polynesia*
<>*Polynesia*
<>*Melanesia*
<>*Melanesia*
<>*Senegal*<>*Senegal*<>*Ghana*<>*Ghana*<>*Benin*<>*Benin*<>*Nigeria*<>*Nigeria*
<>*Cameroon*
<>*Cameroon*
<>*Bantu*<>*Bantu*<>*San*<>*San*<>*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*
<>*America*
<>*America*
<>*Polynesia*
<>*Melanesia*
<>*Senegal*<>*Ghana*<>*Benin*<>*Nigeria*
<>*Cameroon*
<>*Bantu*<>*San*<>*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...
 
 
 
Filters DNAGedcom
Filters AncestryDNA Helper
Text Filters
Fula examples
Malagasy examples
 
 
Main menu