I am looking for a tool, preferably an excel template, I can run on my computer that I can use for comparing Y-DNA results across multiple types of Y-DNA tests.
I realize some version of this exists on the testing sites themselves, but they all have their issues, independent of all of the results not being on the same site.
What I am looking for and hoping someone has found is the ability to compare two rows (test kit results) and determine the maximum number of matches based on the minimum sized kit of the two.
I know how to do a comparison between two cells in excel and get back a positive or negative result which could be used to compare two static rows and then add those up, but that is not the most elegant way of doing things if the row comparison are always changing. So wondering if there is something else out there I just haven't come across yet.
Some examples:
- Test Kit A (Y-37) Test Kit B (Y-111) would only compare the Y-37 markers present in both kits and provide a differences or a match count in a cell up to a maximum of 37.
- Test Kit A (Y-111) Test Kit B
(Y-12) would only compare the Y-12 markers present in both kits and
provide a differences or a match count in a cell up to a maximum of
- Test Kit A (Y-67) Test Kit B (Y-111) would only compare the Y-67 markers present in both kits and provide a differences or a match count in a cell up to a maximum of 67.
- Test Kit A (Y-111) Test Kit B (Y-111) would only compare the Y-111 markers present in both kits and provide a differences or a match count in a cell up to a maximum of 111.
