Does anyone know how to generate a uniquue ID reference for an individual or what systems are already in existance?
I want to combine the 1901 and 1911 census extracted relating to my family name of Barry, so Ideally each person should have a unique ID or primary Identifier. there are approx 9500 people in each census. I have experimented with one made up of [Surname]+[Given Name]+[DOB]+ [Marital status] + [ Place of Birth]which works quite well but there are still several instances of the same sequence being generated because of the limited and repetetive use of the same group of given names.
The information is held in excel Spread sheets, which allows a good range of sorting and filtering arrangements and marcos so it won't be difficult to do what I want if each person can have a unique identifier.
Within one census data its OK as you can use a simple numbering system for each individual, however that doesn't help when the other census data is added, or when family groups are extracted from head of family filtering to then subtract these people from the whole census
Any suggestions please?