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

Quote:

---

Originally Posted by Graham

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.

Quote:

---

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.

Quote:

---

Originally Posted by Jaxman

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.

Quote:

---

Originally Posted by Longbowman

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.

Quote:

---

Originally Posted by Atlantic Islander

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.

Quote:

---

Originally Posted by Longbowman

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

---

You are so mean omg, lol.

MtDNA
H 64
H1 62
T2b 33
V 31
H3 25

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

Quote:

---

Originally Posted by Jackson

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.

Quote:

---

Originally Posted by Longbowman

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

---

Nah didn't do it.

Quote:

---

Originally Posted by Jaxman

Nah didn't do it.

---

http://0.tqn.com/d/rubberstamping/1/...ou_words_1.png