Advanced Excel Filter Settings

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM
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	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions
9	<>Balochistan	<>Baltic	<>Basque	<>Burusho	<>China	<>Dai	<>France	<>France	<>Germany	<>Germany	<>GreeceAlbania	<>Gujarati	<>India	<>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	<>Mexican	<>Mexican	<>Portugal	<>Portugal	<>Spain	<>Spain	<>CentralAm	<>CentralAm	<>ColVen	<>ColVen	<>England	<>England	<>Ireland	<>Ireland	<>Scotland	<>Scotland	<>Wales	<>Wales
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	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	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	<>Mexican	<>Mexican	<>Portugal	<>Portugal	<>Spain	<>Spain	<>CentralAm	<>CentralAm	<>ColVen	<>ColVen	<>England	<>England	<>Ireland	<>Ireland	<>Scotland	<>Scotland	<>Wales	<>Wales
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	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions
21	<>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	<>Portugal	<>Portugal	<>Spain	<>Spain	<>England	<>England	<>Ireland	<>Ireland	<>Scotland	<>Scotland	<>Wales	<>Wales
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	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	ethnicregions	ethnictraceregions	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	<>Balochistan	<>Burusho	<>China	<>Dai	<>Gujarati	<>Gujarati	<>Japan	<>Korea	<>Persian	<>Philippines	<>Vietnam	<>ColVen	<>ColVen	<>India	<>India	<>Pakistan	<>Pakistan	<>Mexican	<>Mexican	<>Samoa	<>Samoa	<>Tonga	<>Tonga	<>ArgUruBrazil	<>ArgUruBrazil	<>Mexico	<>Mexico	<>Canada	<>Canada	<>Yucatan	<>Yucatan	<>Cuba	<>Cuba	<>Maya	<>Maya	<>Hispaniola	<>Hispaniola	<>Central	<>Central	<>Peru	<>Peru
28
29
30	5) More inclusive European filter (leaves in trace regional amounts of minor African/Asian/Pacific admixture)
31
32	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnictraceregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions	ethnicregions
33	<>Asia	<>China	<>Dai	<>Japan	<>Korea	<>Philippines	<>Vietnam	<>America	<>America	<>Polynesia	<>Melanesia	<>Senegal	<>Ghana	<>Benin	<>Nigeria	<>Cameroon	<>Bantu	<>San	<>Mali	<>Puerto	<>India	<>Mexican
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