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.