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
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
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
ethnicregions
ethnicregions
ethnicregions
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
ethnicregions
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
ethnicregions
ethnictraceregions
9
<>*Balochistan*
<>*Baltic*
<>*Basque*
<>*Burusho*
<>*China*<>*Dai*
<>*France*
<>*Germany*
<>*GreeceAlbania*
<>*Gujarati*<>*Italy*<>*Japan*<>*Korea*
<>*Norway*
<>*Persian*
<>*Philippines*
<>*Portugal*
<>*Sardinian*
<>*Slavic*<>*Spain*
<>*Sweden*
<>*TurkeyArmenia*
<>*Vietnam*
<>*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
ethnicregions
ethnicregions
ethnicregions
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnictraceregions
ethnicregions
ethnictraceregions
15
<>*Slavic*
<>*Sweden*
<>*Norway*
<>*GreeceAlbania*
<>*Germany*
<>*France*
<>*Basque*
<>*Baltic*<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*<>*Slavic*
<>*Sweden*
<>*Norway*
<>*GreeceAlbania*
<>*Germany*
<>*France*<>*Basque*<>*Baltic*
<>*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
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
ethnicregions
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
21
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*
<>*Europe*
<>*AngloSaxon*
<>*Celtic*<>*Ural*<>*Baltic*<>*Basque*<>*France*<>*Germany*
<>*GreeceAlbania*
<>*Italy*<>*Norway*
<>*Portugal*
<>*Sardinian*
<>*Slavic*<>*Spain*
<>*Sweden*
<>*TurkeyArmenia*
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
ethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregionsethnicregions
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*
<>*Balochistan*
<>*Burusho*
<>*China*<>*Dai*<>*Gujarati*<>*Japan*<>*Korea*<>*Persian*
<>*Philippines*
<>*Vietnam*
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...
Main menu