Post your top 5 yDNA and mtDNA haplogroups in your 23andme DNA Relatives list

[Jackson]

MtDNA
H 71
H1 68
H3 45
T2b 32
T1a1 23
Y-DNA
R1b1b2a1a2f* 115
I1* 42
R1b1b2a1a 39
R1b1b2a1a1 26
R1b1b2a1a1* 23
R1b1b2a1a2f 23
R1b1b2a1a2f2 21
R1a1a 20
I1 16

How many do you have in total, so percentage wise how are lineages represented? Would be interesting to see how they compare to averages in the British Isles.

[safinator]

Y-DNA

51 - E1b1b1a2*
47 - I2a2b
39 - R1a1a
25 - I1*
24 - J2

MtDNA

75 - H
50 - H1
21 - T2b
20 - H7
18 - J1c

Ironically neither my paternal or maternal line are among my top 5 matches.

[Atlantic Islander]

Okay so how the hell do you do this lol?

Use google docs. Follow the instructions linked here, it doesn't take long at all.

[Atlantic Islander]

Get a pen and paper, go through the list, and tally them up. Should only take a couple of hours and it's good fun.

Dude no. Dowload the file - upload to google docs - click on it - data - pivot table report - rows - add field - maternal haplogroup - uncheck show totals - values - add field - maternal haplogroup - summarize by countA

Repeat with Paternal haplogroup.

Seriously it's way easy.

[Longbowman]

Dude no. Dowload the file - upload to google docs - click on it - data - pivot table report - rows - add field - maternal haplogroup - uncheck show totals - values - add field - maternal haplogroup - summarize by countA

Repeat with Paternal haplogroup.

Seriously it's way easy.

My way is funnier. Perhaps Jaxman actually did it the hard way.

[Atlantic Islander]

My way is funnier. Perhaps Jaxman actually did it the hard way.

You are so mean omg, lol.

[Patches]

MtDNA
H 64
H1 62
T2b 33
V 31
H3 25

Y-DNA
R1b1b2a1a2f* 106
R1b1b2a1a 53
I1* 35
R1b1b2a1a1* 34
R1b1b2a1a1 24

[Graham]

How many do you have in total, so percentage wise how are lineages represented? Would be interesting to see how they compare to averages in the British Isles.

Will need to do it all again. But I'll try to copy what you've done.

[Black Wolf]

My way is funnier. Perhaps Jaxman actually did it the hard way.

Nah didn't do it.

[Longbowman]

Nah didn't do it.