Bill's Genealogy Blog

Bill Buchanan is a long-time genealogy enthusiast, living at Onoway, Alberta, Canada. This blog will describe my experiences as I research my family history and help others.

My Photo
Name:
Location: Onoway, Alberta, Canada

I am a retired online school teacher. During July 2007 - January 2010, and September 2011 until the present I have provided part-time support for https://familysearch.org This is very rewarding. I have helped many with the free Personal Ancestral File 5 (PAF5) software. I continue to help others with the Family Tree and related FamilySearch products.
Since April 2010, I am an assistant director of Edmonton Riverbend Family History Centre. I have a FHC blog at Bill's Family History Center Blog For information the Latter-day Saints and family history click http://mormon.org/

Wednesday, May 02, 2012

The Irish Census Meets Microsoft Excel

My Buchanan family left Ireland in 1847, so what interest could I possibly have in census records from 1901 and 1911? We have found a perfect 67-marker Y-DNA match between our family and the Buchanan family of Kirlish, Drumquin, Tyrone. This family and various other Buchanan families from the area are in these censuses. How do we sort them out?

Firstly I searched the 1901 and 1911 census for all people with surnames starting with Buchan, to include Buchanan, Buchannan, Buchanon, and other variations. But our family name is always spelled "Buchanan"! Not really, it was spelled however the clerk decided to spell it on that particular day! So I am trying to cover the bases. 

Then I copied and pasted the search results into an Excel spreadsheet for that particular census.

Then I sorted the records by decreasing age (I want the parents listed first, then the children).
Then I sorted by townland to separate the families.
I now have all of the Buchanans living in Tyrone in 1901 listed by families, and the same for 1911.

Now I need the help of local people (probably interviewed by Darlene and Virginia) to tell which families are related to each other and what the connections are. I hope David can get us started with this.

It is a way to maximize the benefits of a genetic match in terms of real people.

0 Comments:

Post a Comment

<< Home