Note:  A new version, MatchCompare v3.03, is now available for download. This version was rewritten by Dermot Balson. With this version, it does not matter which column the input data begins in.

To download the macro, click on the above menu button that says "MATCHCOMPARE."  

To view the video, click on the menu button that says "VIDEO TUTORIALS."

About MatchCompare and What It Does

Link to BYU Presentation

The object of this method is to find those matches that are in common with (ICW)  and not ICW you match list.  Depending on which match lists you compare, you can narrow down your match list to a group of matches that are likely to be related to a specific line of your family.

For example, if the first match (red) list represents you and the second match list represents your maternal first cousin (green), then the ICW area (green), which matches in both lists, will consist of people that are likely to be related to you on your maternal line.  The red Not ICW area will consist of matches that are likely to be on your paternal line with a smaller number of matches that are also on your maternal line, but just were not one the matches that you first cousin had.  You can make this analysis more accurate by adding sibling matches to the your list of matches and by also adding maternal cousins to the green match list.

MatchCompare can relatively quickly compare to large match lists and give you a list of matches that represent your paternal, maternal or uncle family lines.  

Additional comparisons can be made to narrow down your match list as shown in the video if you know of matches that are 2nd, 3rd or 4th cousins.