I'm looking for a repeatable system, I have FTM Family Tree Maker 2012, but the data is held in MSExcel 2003/07/10.
I would like to be able to apply the system maybe a macro or simple copying and dragging down the rows in excel. It could be Visual Basic for applications.
The problem is that even with five elements the results aren't unique, but at least it would give consistant results across both census, even if there are a few manual interventions required. It may not be obvious that having filtered the heads of families, the dependant that are then extracted from the census data base online are correctly referenced into a family but the connection to the full list of people is not made, so unless you look at each instance manually with or without the identifier there is still alot of time and effort required.