Aye lad.
Update:
YDNA:
1 R1a1a 49
2 E1b1ba2 43
3 I2a2b 22
4 I1 21
5 J2 15
mtDNA
1 H 62
2 H1 20
3 H7 15
J1c 15
4 T2b 14
H1c 14
5 H6a1 13
Update!
mtDNA
H - 78
H1 - 39
J1c - 23
T1a1 - 13
H7 - 12
U5a1a1 - 11
H1c - 10
Y-DNA
E1b1b1a2*(E-V13) - 75
I2a2b - 44
R1a1a - 42
R1b1b2a - 23
J2b2* - 20
R1b1b2a1a2f* - 18
I1 - 18
Mine:
mtDNA:
H- 74
H1- 69
T2b- 43
H3- 35
T1a1- 16
H7- 16
V- 16
y-DNA:
R1b1b2a1a2f*- 94
R1b1b2a1a- 59
Il*- 47
R1b1b2a1a2f2- 23
R1b1b2a1a1- 21
R1b1b2a1a1*- 21
Il- 19
Self:
mtDNA (L2a1l2a1) top five:
K1a1b1a - 115
H - 52
H1 - 32
H7 - 31
J1c - 30
Y-DNA (J2) top five:
J1e [J-P58] - 75
R1a1a - 37
E1b1b1c1 - 34
T, R2 - 33
Grandmother:
mtDNA (L2a1l2a1) top five:
K1a1b1a - 185
N1b2 - 54
H - 46
K2a2a, H1 - 40
Y-DNA top five:
J1e -76
R1a1a - 37
E1b1b1c1 - 36
J2 - 33
E1b1b1c1a - 31
Grandfather:
mtDNA (H10a1a) top five:
-Still waiting for list-
Y-DNA (I2b1* / I2a2a*) top five:
-Still waiting for list-
Grandfather:
mtDNA (H10a1a) top five:
H1 - 49
H - 42
T2b - 30
H3 - 25
H7 - 23
Y-DNA (I2b1* / I2a2a*) top five:
R1b1b2a1a2f* - 68
I1* - 51
I1, R1b1b2a1a - 44
R1a1a - 43
Wasn't there a method to organizing these into order quickly and easily? Been a while since I've done it and google docs layout seems to have changed, anyone able to give me some advice on what to do?
I just downloaded the csv. file, opened it in Excel and sorted the paternal and maternal haplogroup columns by alphabetic order. Then, if you mark enough cells a small number pops up next to your coursor with the count. It was pretty easy to spot which halpogroups had the most instances since there is usually a vast variation in numbers.