Thank you for this video! I will definitely be rewatching. :)

EXACTLY The Info I Need!. Thank You!!!

Aww, first video I’ve watched with both of you, y’all are too cute. Thanks for these great videos.

Thanks to you both!! I have attempted Leeds charting several times… and produced nothing but nonsense. I really didn’t understand what I was doing. I still don’t quite get it. The process you used looks like it would work to identify cousins for a missing father or grandfather but I am striving to find my Paternal Great Grandfather, Mr Sperm Donor. I suspect that for this to work, I would have to use a lower range to select 3rd-4th cousin matches with an 8 to 16 column spreadsheet spread. I especially want to thank you for your spreadsheet operations. The way you used formulas was new to me. Although I have been using them since Lotus 1-2-3, mostly it has been for budgets, Balance Sheets, etc. I have attempted to copy matches from Ancestry and 23andme… but my efforts were crude and tedious compared to your methods. Thanks again, Ray Buker

Very useful, thank you!

Missed this one this morning. Catching the rerun.

This is great. I like that you showed your mistakes. I learned a lot about excel through this too. Not often I follow step by step without having to skip forward.

Thank you for evolving my DNA cousin matches spreadsheets! I'm digging exploring the LEEDS method more; yet I do have endogamy. I do see it being helpful for clustering matches along the grandparents lines too. Thanks for the spreadsheet formula expressions tips too! 38:26 You mentioned this about 23andMe's Relatives in Common feature (kzfaq.info/get/bejne/nLV4prV8q63Rj5c.html) 23andMe tip for this process: When you are connected to your DNA cousin match and use the Relative in Common feature, it will evolve the Relatives in Common feature to display how you are connected to each of your DNA cousin matches compared to the DNA cousin match's matches. Therefore, the Relatives in Common columns on the 23andMe Relative in Common tool display like this: The first column is your DNA match’s name as displayed on 23andMe. The second column displays your DNA cousin matches list and either your predicted relationship or the relationship you choose to edit your DNA cousin match as your known relationship to that match. Then, it displays that result and below in parentheses it shows the percentage of your DNA shared with that DNA cousin match. This helps for not having to jump back to your DNA cousin match list to see the percentages again. Note: I have changed my known relationships to some 2C1R and 3C1R, which is helpful for my side. Yet, I wish the DNA cousin match would update if they know the relationship more than the predicted relationship for each match, if known. I saw this recently when someone updated the relationships for grandfather, father, son, for example. Then, this becomes definitely helpful for working together with your connected DNA cousin match. The third column displays your DNA cousin match’s list and either their predicted relationship or the relationship they chose to edit the DNA match cousin as their known relationship to that match. Then, it displays that result and below in parentheses it shows the percentage of DNA shared with that DNA cousin match has with their DNA cousin match. Note: If your DNA match doesn’t update the known relationships with their 23andMe DNA matches, then be careful and refer to the percentages for further guidance. Unfortunately, it’s a lot of work to extract this info to sort for your DNA cousin match’s list. Therefore, you are utilizing your DNA cousin matches list sorted by your list being first priority in ranking. If you want to rank your DNA cousin match’s list, then you could add a column to manually, add each of match’s percentage, and do a calculation to get a rough estimate of the shared cM amount that that DNA cousin match has to their DNA cousin match in their list. The fourth column displays the DNA overlap with a “Yes”, “No”, “Not Available”, “Request Sent”. 1. The “Yes” means the DNA overlaps on the same segment(s) (just a clue that it overlaps somewhere) 2. The “No” means there is no DNA overlap on the shared segment(s) 3. The “Not Available” means you are not connected to the DNA cousin match to fully share each other DNA results 4. The “Request Sent” means the request you sent to connect is still pending Sadly, I haven’t figured out a way to sort to rank the DNA cousin match’s list easily and I don’t like having to tab at the bottom for every 10 DNA matches to compare. It’s a bit inconvenient. If you were able to extract out the pages of shared DNA matches between you and your DNA connected cousin match, then you could sort their match list too for further clues. Tips for 23andMe users: When sending invites to DNA cousin matches, it gives a few extra, deeper views for further DNA research. Both of these are hidden until you connect with the DNA match. 1. When expanding the “View DNA details” feature, it will then show the chromosome browser along with the cM’s and the percentage view for convenience when looking at the chromosome browser. 2. When expanding the “Find Relatives in Common” feature, it will then show further info between the two DNA shared matches (see above for the middle columns display info) by stating whether or not there is DNA overlap. Good luck on everyone’s DNA cousin solving journeys! Let’s keep working together!

time to rewatch. And start working on a new Leeds chart.

I only have two DNA matches between 400cM and 90cM on 23andMe! I'm in the UK though. I have only 9 matches in the 400-40cM range. I have 41 matches in the 400-30cM range so I'm going to try with them, although I suspect this wont work as the genetic distance will be too high. If anyone has helpful suggestions or comments about this, that'd be great. Thank you both for the video. Please can I ask why you include the X DNA in the total genetic distance? I'm not familiar with 23andMe yet, I've only cluster matches on Ancestry and MyHeritage where X is not included. Thanks.

Thank you for the bottom line dealing with a pedigree collapse & endogamy : it was suggested to me that Leeds might be of use in sorting out my conundrum. Grand parent ducks line up, but with one, I have no 1C or 2C -& no 3C match me. Six of the 8 gg grandparents are also good. My maternal grandmother's maternal grandmother raised her- DNA matches support this, confirmed by those of a 3C I've found- similar range of numbers. So: a 'sister ' had her- with help from one of the 8 sons of a family well-represented in my matches- including their remote cousins. As yet I've not been able to zero in on which. (It's taken me 75 years to get this far.) Problem: her maternal grandfather 's name bears no relationship with my - nor my cousins ' - DNA. Where they should be, I have an identifiable "bunch " of matches, centred on a couple I suspect to have been his grandparents. In addition to numerous pedigree collapse, they (ir)regularly married with one other family, & occasionally, with 2 others. How to find 2 ancestors in this mud-pie... I have at least 70 matches with family #1 - most around 14cM - where they belong!-(they match with the "strong " ones, and descendants of their remote ancestors are in there too. Where cMs are high- 40 to 60 - I can expect to see pedigree collapse, & I do- but not all were created equal: I'm finding pc at 14cM. My current project is to sort them by which children are involved- see if patterns emerge. I'm not sure if at the same time I can sort by what other family is involved. Eventually I'll get to details of age, place , time, marriage date. I doubt if I'll ever be sure I've found his parents- a couple of probable possibles may have to do. A more realistic goal may be to 'settle' on his grandparents... Thoughts? Observations? Suggestions?

You can use Pivot tables to add up quickly the Genetic Distances.

I found my matches changed list position when I labeled the match with known relationship. Thus a known second cousin with a low shared cM was shifted to a position higher than match with a longer shared length of cM

Also when filtering, had you selected to keep the zero's and blanks you wouldn't have to go through all those extra steps. It put a 0 next to the first time the name appears and 1's next to all the others. So had you selected to filter out all the 1's in the beginning that would have done the trick.

Trying to follow along and having to replay the 'structions :) multiple times. The problem is, I have a different version of Excel and I had to look at your screen capture a couple of times to even find "freeze" for the top row.

Is the Donna Leeds method the best method to find the paternal line of a person? A friend of mine did several dna tests but we can’t figure out which is paternal or maternal…

I have a small amount of DNA from India. Is there some way to match with others on 23andme that have DNA from the same area?

I am totally confused. I had not heard of a Leeds Chart until I started watching your videos - which I loved. However, wWhat is the exact purpose of a Leeds chart? How does it help with my brick walls which are at least 3 generations back (g-g-grandparents) in the early 1800's?

*What does LEEDS stand for?* Is it an acronym or a name or does it mean it takes us someplace (as in leAds)? Googled it and found out it's a chart named for the person who developed it. "The Leed's Method was termed by Dana Leeds, a genealogist who works as a 'Search Angel' sorting through DNA matches on unknown parentage cases. She implemented a strategy to color coordinate DNA matches in a spreadsheet which allowed her to determine which DNA matches were related to each other. Dec 23, 2022"

I have a overlap question. How can we know if we're seeing endogamy/pedigree collapse vs matching through each of 4 unrelated parents? I hope that question makes sense. I know what I'm trying to say, but words are not my friend right now. I'm fighting my way through the wonky 23andMe match list (why can't the folks be in consistent order?!) and I am finding some overlap. The two points of overlap are with 2 of my matches involving adoptions. With the one, he and his mother (the adoptee) are in my maternal grandpa's column. I know where they go in my tree on Grandpa's side. The mother is my 2C. He is also in an unknown column, but his mother is not in it. I don't have any idea how that unknown column lead fits into my tree. The next adoptee is in my paternal grandma's column as well as in that unknown column with the first guy. He is just outside the 400cM to 90cM range at 89cM. I know which side he goes on, but I do not know where he goes in my tree. I know that most cases could possibly be worked out by viewing the chromosome browser, if that is available for that particular match, and if all 4 parents have been tested. In this case, the mother and son and the 2nd adoptee have all connected with me. I do not see any segments that the son has that his mother doesn't have. They won't upload to GEDMatch. So, no answer there. My parents have tested, but not on 23andMe. Both are on GEDMatch. But, what about when it isn't available, like when they won't connect, or they are on Ancestry, or elsewhere, but won't upload to GEDMatch? How do you figure it out then?

My sister & I are from the same parents. My sister recently did 23andme & somehow we have a 1st cousin 17+% that we don't know of (?) that also spells his name differently from ours. Ours Larson, his Larsen. To our knowledge-We only have one deceased paternal aunt. It says we share grandparents so does this mean my deceased paternal aunt had another child or that we have another aunt or uncle floating around? Very confusing if you haven't done this before. We're just curious & like mysteries lol. Can anyone offer anything further? I'm hoping that's enough info to go on.

23&me no longer shows the shared dna any more after their security breach nor the download dna relatives data button. leaving only the hand entry and calculations. making 23&me a lot less useful to me.

I think the Leeds method for my 23&Me matches isn't helpful. I don't have enough testers among them from all my lines. I have already identified most of the relationships, too, so I'm using the information I already have to try to make the chart work. Is it more useful when we first start out in genetic genealogy?

Hi, from Jordan! 👋 What program will I need to construct a Leeds chart?

I have a double whammy of having a recent pedigree collapse (Dad was born in 1915 and his parents were first cousins) and my paternal grandmother was one of 12 children. All but one of my matches in the 400-90cM range ( 8 matches total) are descendants of my paternal grandmother's siblings. Is there a work around for this?

Not all show the cM - if you are not connected with them

I did not get the Formulas to work properly especially SUMIFS what am I doing wrong? I tried to write them axact as Andrew did !

From my experience, 23 and Me sorts shared matches by strength of relationship, then by percentage DNA shared.

Can you do a Leeds chart for great grandparents? There are no living parents or grandparents to test.

The problem is of people on 23and me aren't opted in to share their information it'll only show percentage not cM. I use DNA painter for these.

YIKES. If I'm adding the genetic distance correctly, that only leaves 10 matches over 90! That's less than is even in my predicted family tree! Guess I can't even do this..

Does it matter if the match is a X Chromosome only match? My mum has some large X only matches.

I have 5,004 dna matches in 23&Me. Is that typical?

But what if my highest match is 148 cMs? Can I go lower than 90 cMs? How far should I go? 44 cMs? :(

Does the 23andme relative in common really shows that these people are related?

You've killed my brain.

How do second cousins share a grand parent? I thought they shared great-grandparents.

Q-Why does your shared relatives pages look different than on mine? Nevermind I think it is because you are on a computer not a mobile phone or other device!

Matches 400-90cM ignoring 1st cousins

Geez, is there a quicker way that this spreadsheet hell?

How about an adopted brother on my mom side

You are making this too complicated; since 400cM approximately equals 4% just use percentages.