Hello. I was researching some family and i ended up on the same census from 1841 mentioned in this thread. My family name is Middlemiss (mostly from Edrom /Berwickshire) and the person I was looking up was a G-Grandmother named Agnes Bruce who married married a Richard Shortreed Scott. They went on to have Betty Shortreed Scott who married Thomas Middlemiss.
When I looked up Agnes Scott and then Agnes Shortreed I found the 1841 census and saw that the age of 97 made her the same age as my Agnes...plus she was living with an Andrew Middlemiss. that names reoccurs in my family, My Grandfather Thomas had a son Andrew in 16/06/1805 (In Edrom) and that Andrew had a son of the same name born 28/09/1834 at Whitsome /Hilton with a woman named Beatrix Bertram.
I mention all this because I believe there is some kind of a connection between Agnes Shortreed and my Agnes Shortreed Bruce. Also because Andrew Middlemiss could possibly be related. My family was in Berwickshire but I never did find Agnes Bruce birth for certain and so she could very well be from Roxburghshire (also Richard Shortreed Scott could be from there).
Not sure how this Andrew Middlemiss born about approx 1820 and my Uncle Andrew born 1805 (or his son born 1834) could be related. The only birth of an Andrew on SP site I could find was a 1826 from Roxburghshire.
If anyone has any comments or info they could offer it would be greatly appreciated.