This is a step-by-step guide and case study on using the Leeds Method with mostly 4th Cousin DNA Matches on Ancestry.
What is the Leeds Method?
The Leeds Method is a way of color-coding your DNA matches into ancestral groups without needing family trees to do so. The aim is to discover four clusters of matches that correspond to the direct line of each grandparent.
It was developed in 2018 by Dana Leeds to help someone identify unknown biological family. Many people with solid family trees now use the Leeds Method to research their mystery branches.
Who Gets Most Benefit from the Leeds Method?
Like all techniques, the Leeds Method goes awry with endogamy. Apart from that, the general recommendation is that you get the best results when:
- You have many 2nd-3rd cousin DNA matches (Dana suggests 6 to 8)
- Your grandparents come from different areas (less chance of inter-marriage up the lines)
So, what about yours truly? Is it looking good for me? Heck, no!
- I have two 2nd-3rd cousin DNA matches on Ancestry (and none elsewhere).
- Both my maternal grandparents hail from the same area.
But I like a challenge, and I’m a sucker for analytical techniques. This article is my case study of an Ancestry tester who has far fewer DNA matches than the average American customer.
With only two 2nd-3rd cousins, I need to pull in my fourth cousins to get enough data i.e. enough DNA matches. Dana has warned about the limitations for someone with my profile. But my research goal is not ambitious: this will be successful for me if I derive some new insights.
Can the Leeds Method be used with 4th Cousin DNA Matches?
This article would be rather short if the Leeds Method couldn’t be used with 4th cousins, and I’m not the first person who has tried to do so.
Dana Leeds has a couple of articles that discuss extending her process down the DNA match list. But her articles are predicated on having an adequate number of 2nd-3rd cousins. And “adequate” is definitely more than what I have. So, I took a wander around the interwebs and ended up on Reddit (of all places) – where several people discussed using the Leeds Method with more distant matches.
One guy reported success with fourth cousins above 70 cM.
I think it’s fair to say that if you have to drop into fourth cousin territory, you’re best off having many of them in the upper end of shared centimorgans. Once again, I’m at a disadvantage: all of my 4th cousins are below 60 cM.
But another poster went down as far as 24 cM, with a total of about 50 matches. I’ve got over 60 matches in that range, so that raised my hopes. A third guy recommends 30 cM as a cut-off,.
One thing I gleaned is that the downside of the lower matches is ending up with far too many colors to achieve any form of clustering.
Jumping into the Facebook groups, I noticed that Australian and New Zealand testers had a similar profile to me. They also lack the pages of 2nd-3rd cousins that many of our American counterparts enjoy (or feel swamped by). One poster started by using only the higher matches. She commented about her clusters:
“it quickly became apparent mine didn’t look like examples she [Dana] had given. Extending it out further has worked much better for me.
Why Use the Leeds Method with Ancestry DNA Matches?
Ancestry lacks some of the more sophisticated tools provided by other DNA sites. MyHeritage provides an automated version of clustering shared matches, and other third-party tools do similar. Some tools used to work directly with Ancestry matches until the company applied strict rules on access. These tools, such as Genetic Affairs, continue to work with other test sites.
In contrast to the automated generation of clusters, the Leeds Method is done by hand. You don’t even need to use spreadsheets, graph paper and colored markers will suffice. But it does take your time.
So, why on earth would people work with Ancestry – and use a time-consuming manual method? Because Ancestry has the biggest DNA test database of all the main sites – by quite a margin. The more matches you have, the better the chances that some will fall across each of your grandparents’ lines.
What Could the Leeds Method Tell You?
It’s useful to see what a “perfect” outcome might look like. Let’s skip how we got there, for the moment. Here is a spreadsheet with my dream results (match names have been changed). What are we seeing here?
Shannon, my highest match, has two shared matches above the chosen cut-off point: Nicole and Susan. Scan your eye down column B. Shannon has been assigned the color of black, and each of her shared matches gets the same color.
In column C, Joseph and his three shared matches are orange. Carol is green in Column D, along with her three shared matches. And finally, Connie and her two shared matches in Column E.
There is no overlap across the shared matches: no match is on the shared match list of two of Shannon, Joseph, Carol, or Connie. Every match is accounted for within the four groups: we didn’t have to add an extra column to accommodate an outlier.
So, four distinct groups of shared matches. Our working assumption is that each grouping represents one of our grandparents. Which one? Well, now we go back to the traditional research of examining trees for connections.
A Less Perfect Outcome from the Leeds Method
Perfection is rarely attained. Even testers with a high volume of 2nd to 3rd cousins may get an outcome like this:
You see that Jean has been assigned two colors as she falls into two groups of shared matches. Mark J is on his own with no shared matches, and we had to start a new fifth group for Karen.
Our groups are lopsided, with one line getting the most shared matches – and we’re not sure what to do with the fourth and fifth groups of loners. Yet, there’s still a lot of insight to be gained.
Now, the question is: how do you get there?
How to Organize Ancestry Matches with the Leeds Method
You’ll find step by step instructions on Dana Leed’s website that apply to any DNA site of your choosing. I’m going to provide a walkthrough using Ancestry in this article. There are a few nuances and short-cuts that may help.
You can watch our video walkthrough or follow the illustrated steps in the rest of this article.
A Video Walkthrough of the Leeds Method with 4th Cousins on Ancestry
Step 1 – Prepare Your Ancestry DNA Match List
Open your DNA match list in Ancestry and use the Shared DNA filter to enter a custom centimorgan range. Set the top range to 400 centimorgans, as recommended by Dana Leeds. Remember – the method requires you to avoid including a match with whom you share two grandparents.
Ideally, your lower limit would be not below 40 cM or so. I’d only have seven matches with that cut-off, so I’ve lowered it right down to Ancestry’s fourth cousin threshold of 20 cM. Then I’ll grab the top fifty matches and see how I get on.
Step 2 – Copy Your Matches to a Spreadsheet
What, type them in one by one? Yes, it won’t take long. Use an alternative method if you have one. What’s that? You’d like an alternative method? You can download our Excel workbook and follow the steps in the walkthrough video – get the details at the end of this article.
So, my spreadsheet starts out with just a column of names like this (match names have been changed):
I’m making no assumptions about two pairs of grandparents: this is simply group 1, 2, 3, and 4.
The group colors have been assigned. Having them in the header means they are handily available to be copied quickly into a cell below. But it’s worth putting a bit of thought into your colors.
Step 3 – Select and Prepare your Colors
It’ll be a lot simpler if you think of your coloring scheme upfront. Because if you don’t, you’ll probably want to change it in the future. The basic grandparent split is maternal/paternal. So you may want two very contrasting shades of blue versus two shades of pink.
But think also about the possibility of extending your research up a generation (and downwards in terms of lower matches). Instead of looking for four grandparent lines, you may start thinking of clustering into eight great-grandparent lines. And although there are enough blue shades to differentiate between four groups, I personally don’t find that the pink shades are easily distinguishable.
Which reminds me of my gran’s joke: what’s the difference between a stoat and a weasel? One is weaselly distinguishable, while the other is stoatly different.
Now think of what you’ll do if you haven’t identified most of your higher matches as maternal or paternal. Starting off, you’ll need a set of colors that represent groups that are not yet identified.
Spreadsheet Tip – Keep an Area for Your Color Palette
In my example above, I have the colors laid out in the header of my list. Alternatively, stick them into empty cells in a spare area of your spreadsheet. This means that when you’re coloring in the DNA match cells, you don’t have to open the spreadsheet’s color palette and go looking for that particular shade of green (or was it the green next to that green?) You just copy-and-paste from the empty colored cells.
Ancestry Tip – Use the Ancestry Group Colors
We’re doing this exercise in a spreadsheet, but you may want to work with Ancestry’s group feature. These offer color-coding matches with 24 different colors. I suggest you pick from Ancestry colors (that you are not already using).
This pic is my best guess at representing the Ancestry colors in an Excel spreadsheet. Use this link to get a copy of the Excel workbook, and modify as needed.
Step 4 – Color Code your First Group
Start with your highest match, who is hopefully a 2nd-3rd cousin. If you already know if this match falls on the paternal or maternal side, then pick a color representing that divide. If you haven’t identified your connection, then pick one of the colors you set aside in the “haven’t a clue” block.
You simply plopping the color into the first cell beside the match i.e. Column B.
Now open the Match Profile page in Ancestry and go to the Shared Match tab. Work down your spreadsheet, assigning the same color to Column B for each of the shared matches. You’ll end up with something like this:
Step 5 – The Leeds Loop
You’re nearly finished the instructions, but not the work.
You now have a spreadsheet match-list where some have been assigned colors.
- Go to the highest match that has not been assigned a color.
- Pick a color from the palette and color the cell in the next unused column.
- Open the Shared Match tab in Ancestry for this match
- Assign the same color to each shared match in your spreadsheet.
- Loop back to (1) and repeat until there are no more matches.
That’s it! At some point, you’ll be done. And I don’t expect you’ll have the perfect four colored columns.
You will probably have matches that get assigned two colors, as we showed in an earlier example.
You will probably have more than four colored columns.
Discarding Matches from the List
I encountered two scenarios which prompted me to boot a match from the list.
The first were two match names with the same surname, similar centimorgans, and the same shared matches. I inferred they were brothers, and the second match had no value to add. Why exclude one of these guys? I ended up with 11 colors, with some having a smattering of matches. With those small numbers, an extra match gives undeserved weight – if only from a visual point of view.
The second scenario was a DNA match in splendid isolation – all our shared matches were below the threshold I’d picked. There’s little point having a single-match cluster, so this lot were kicked to the kerb.
My Case Study Results with Ancestry DNA 4th Cousins
I mentioned earlier that I have two barriers to a successful outcome with the Leeds Method.
- Only two 2nd-3rd cousin matches on Ancestry.
- Both maternal grandparents from a common region.
I omitted a third major issue: I don’t believe I have any paternal DNA matches within the threshold I chose. My paternal side is from a region where the population does not engage in consumer DNA testing. That means that my ideal outcome was two clusters!
With wild optimism, I started my spreadsheet with two two colors of varying pink. As I worked down my DNA match list, I watched my number of colors increase with weary resignation. I’m jesting a little – Dana Leeds has clearly flagged the limiting factors, so my less-than-ideal outcome was not unexpected.
So this is what I got with two second cousins and 24 fourth cousins (match names have been changed). My cut-off point was 30 centimorgan. I may dabble with going lower, but nine groups is not wildly useful.
Insights from using the Leeds Method with 4th Cousins?
I won’t say that there are no insights to be had from my particular case study.
I’ve long suspected inter-marriage across my maternal grandparent lines, but haven’t been able to track it down. One of the matches in the spreadsheet has been assigned four colors: and two of those groups contain a known match from the two different lines. If this match had a fantastic tree, I might be able to see the intersection. Of course, she doesn’t have a tree!
I’d already zeroed in on that particular match as a “person of interest” in this regard: but it’s a further visual clue towards where to pursue my research. My next steps are to continue building out my tree to connect with my 4th Cousin DNA matches.
Our Excel Workbook for Ancestry and the Leeds Method
Our Excel Workbook contains a macro which will format your selected Ancestry DNA matches for use with the Leeds Method.
It’s available in our online store: follow this link, enter a zero price, and click “I want this”. When you provide your customer email, you’ll be taken to a page to download the template.
A zip file will arrive in your downloads folder. It contains the spreadsheet.
You may need to take several steps to ensure that you can run the macro in this spreadsheet. Watch this video for each step:
Watch the Video Walkthrough on using the Workbook
If you find this spreadsheet useful, consider donating the price of a cappuccino ($5) with the PayPal button below:
Tracking Your Ancestry Matches In Spreadsheets
This article looked specifically at using the Leeds Method with the help of a spreadsheet.
We also have a more general article on downloading your Ancestry matches to an Excel spreadsheet. The general article has a separate spreadsheet template that formats your matches with their tree size and other details. The results look like this:
I loved your Macro to gather the Ancestry matches. Below is a link to the Facebook group where I have posted an excel sheet of Ancestry Color Dots which are much more accurate. It is free for everyone to use.
I hope this is usefull.
https://www.facebook.com/groups/geneticgenealogytipsandtechniques/permalink/853403205123381/?__cft__%5B0%5D=AZU9ImIR5PHKS53cQykI2SZJcp88RzOYlf2VmxANMLFWq_ApWd7ChuAiM5ieHPLwnrV34lEEw8z4bjC5rAYwg81a9A4dEzl8F4pFKZFImG6WCFw6ptYEe95KKwip0yTpTywOJrJlbuCkOVmxLPpjVFbNA0xtoFspx38axX14Jy1xFw&__tn__=R%5D-R
Thank you so much for the link, that does look more accurate than my colors 🙂
I love this explanation and the spreadsheet. I had used Dana’s method before, but your article and spreadsheet encouraged me to do it again. I worked down to a fourth cousin I had matched and knew through other methods. So, 220 -25 cM. I have 140 matches in my chart.
I discovered how to (in Excel) sort my rows by color when I was done.
I should have started with eight colors. I have a lot of matches through my maternal grandmother, so wanted to identify matches into three groups. GGM, GGP, and Both (2nd cousins in the that line).
Delighted you had another bite at the cherry!
I also understand your comment about regions that don’t seem to DNA test as much. My German cousins don’t seem to test unless they have moved to the UK or US. My Northern Ireland cousins, on the other hand do.
I had a few issues with the macro not filtering correctly – so I derived a workaround myself using : =IF(LEFT(A1,7)=”Managed”,””,IF(LEFT(A2,7)=”Managed”,IF(RIGHT(A3,2)=”cM”,A59,””),IF(RIGHT(A2,2)=”cM”,A58,””))) in column B, so I could find all the names, then with a paste special, values, make those sortable. Hopefully that will help if someone else has the issue!
Thank you for taking the trouble to adding these details!
Where are you pasting this as mine only highlighted the 1st 3 names in red.
can you be a bit more specific as to what you’re referring to? But if the article isn’t clear, try the video.
This video helped me so much in an effort to organize and give priority to all of this information. But the link for the Leeds Method Spreadsheet is not working. I have attempted to look elsewhere, but I have had no luck.
Any suggestions or help would be so very appreciated
Sorry to hear you had trouble getting the spreadsheet. I will send you a link by email.
Using the macro will not color my matches red..
Ancestry changed the web page a little, which broke my code. I’ve uploaded a new version for download. I will send you an email with the link.
Me as well…..
I’ll take a look, thanks for reporting.
I had no luck with the macro pulling up matches in red…??
Ancestry changed the web page a little, which broke my code. I’ve uploaded a new version for download. I will send you an email with the link.
Ancestry changed the web page a little, which broke my code. I’ve uploaded a new version for download. I will send you an email with the link.
Using the macro will not color my matches red.. 4/14/21
Ancestry changed the web page a little, which broke my code. I’ve uploaded a new version for download. I will send you an email with the link.
There seems to be no link for your spreadsheet, if you would be so kind and share it again. Thanxs in advance Mike
Sorry if it isn’t clear how to get it. I’ve sent a copy to the email you supplied with your comment.
Snap please email me too thanks
in the excel worksheet there is no icon for “Developer” to continue
You just need to enable it in Excel. I’ve got instructions at this link.
Hi Margaret,
I improved on your spreadsheet: https://1drv.ms/x/s!AnY4cGihA9l3keIKe_QTmMm96niF0g?e=nH6Rub
I’m working on the mystery of my Dad’s paternal grandmother’s parents and have researched over a thousand matches, but the regular LEEDS method wasn’t cutting it.
I realized looking at shared matches that although they might fall under a particular grandparent heading, that shared match could also fall into one or more of that grandparent’s 16 immediate ancestors (half match, full match, double cousin, etc)! So after I label the match with one or more of our MRCA’s surnames and assign a color, I transfer/copy that whole line to the relevant tab for that ancestor. People near the top then become a proxy for that line.
I also have a GRID tab where I can then paste people that match each other to create my own clusters.
It’s been a game-changer for me and I’ve already discovered two new ancestral lines.
But I’m still plugging away at that brick wall…
Take a look. Hope it helps you or someone else.
–Cheri
P.S. The MRCAs in my list are colored to match their corresponding column and the match lists are in table format to allow easy sorting. In my own workbook I have a tab for each platform, labeled and colored accordingly.
Hey, thanks for showing this to me and other readers. I really appreciate it!
Hi Cheri
I know it has been a while since you have done this, but where the instructions say to click on view / view macro….excel seems to have removed / misplaced / hidden that function. Do you have any idea where to find it at all? Linda
If you don’t see the Developer tab, you can enable it following these instructions.
Margaret, the Options tab just state : Regional format settings.
I do have a customise ribbon option on the far right of the main sheet. This gives me the options of single line single line ribbon or classic ribbon. Those are the only options.
There is no option for a developer tab anywhere. Linda
What version of Excel do you have and what device are you using? For example, the Developer tab isn’t available in Excel Online or the Excel mobile app. It’s also not on the iPad.
Hi Cheri
I managed to purchase Excel and have followed your instructions – note anyone reading this excel have changed where they have placed some things – everything downloaded well. Brilliant charts btw. Now what do I do? I’m a tad lost. TO CLARIFY I do know how to do the leeds method, I just don’t understand how to put it in this chart or where. I don’t really understand the cluster thing. I thought this would make a chart where I could visually see unknown matches and where they fit in. I don’t suppose you have a – real idiots guide- to what I’m supposed to do next? I do know my grandparents names and a few generations above would I put those in?if so where?
Hi Margaret. When I try to enable the macros, I get a message saying the VBA macros are corrupted and have been deleted. So I can’t use the spreadsheet.
Jill
I sent you an email to see if we can figure this out.
Oh my goodness, the new Ancestry update where our matches are now separated by parent is making your macro a game changer. Just downloaded all my matches on my Dad’s side by using the *custom cM range* on the Shared DNA tab AND the *paternal* radio button on the Groups tab on my matches page. I kept copying the Splat tab and going thru the process for the 25cMs, 24cMs, 23cMs, etc. until I was down to 15cMs. Can’t wait to color code all these folks and look for the wall buster!!
Thanks so much again for your tool!!
Delighted to hear it’s working for you!
Margaret for some odd reason I’m having trouble with the macro & splat page tonight. I successfully copied & formatted from the shared matches from myself & several relatives, whom I manage. I’m trying to compile my own spreadsheet to see the cm’s between myself & each shared match & my respective relative & the match. It went fine so far until I got to one page & when I pasted to the splat page (exactly as I’d done every time before) then ran the “remove blanks” & then the macro, it showed the “public linked tree” (as an example) in the column where the cm’s should be & I’m not getting the cm’s, common ancestor, or maternal/paternal side for any of these matches. I realize you’re quite busy, but if it’s not too much trouble, might I email you my file & see if you can figure out what’s gone wrong? I’d greatly appreciate it!
< Meredith
Sure, send me the spreadsheet to support@dataminingdna.com.
Sometimes, something in the notes can derail things.
Hi – Amazing work.
My version, I downloaded today only has 3 tabs – Instructions, Splat and matches. There are 6 columns in the matches tab, the Tree, People, Ancestor and side (what does side relate to?) are all blank. Do I have to populate them manually or has changes in Ancestry’s page affected your macro? I was expecting a colour tab as in your description above.
Excuse my ignorance, but I’m now not sure what the next step is.