Secret Trick for Searching Genealogy Records on Ancestry
Рет қаралды 101,730
Күн бұрынI used my famous data extraction trick to find a missing boy in the census. This is a must see video.
❤️ JOIN the GENEALOGY TV ACADEMY
genealogytv.org/about-genealo...
Learn my secret trick for researching records and how I found a missing 8 year old boy in the 1870 U.S. Census with this unique strategy anyone can use.
There is a handout for this episode. Information about how to to get the handout below.
Note: You will need a recent version of Excel for this trick to work.
** GTV Products, Websites, Handouts and Memberships **
📝📝📝THREE DIFFERENT WAYS to find the HANDOUTS!
📝 1) Become a CHANNEL MEMBER at the INFO ACCESS level $9.99 per month. This gets you all the handouts. www.youtube.com/@genealogytv/....
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at www.youtube.com/@GenealogyTV/...
📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at genealogytv.org/handouts/. Here you will get a redirect and an email to download the handouts.
📝 3) Become a monthly PATRON at the HAPPY DANCE level ($15/Month) or more. You will get early release of the videos and the handouts are emailed to you, when they become available. / genealogytv
📝 All Genealogy TV Academy Members have access to the handouts within the Academy platform.
❤️ BECOME A GENEALOGY TV CHANNEL MEMBER and help support Genealogy TV - see perks!
www.youtube.com/@genealogytv/...
❤️ Patreon Membership - Handouts Emailed as they are produced. / genealogytv .
✅ Genealogy TV WEBSITE
genealogytv.org/
✅ GTV on FACEBOOK
/ genealogytv
✅ SIGN UP For GTV’s NEWSLETTER
mailchi.mp/a0862c6473aa/genea...
👉 Subscribe to Genealogy TV (Free)
/ @genealogytv
** GTV Affiliate Partners **
🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites.
www.amazon.com/shop/genealogytv
🌳 FREE TRIAL to ANCESTRY.com click.linksynergy.com/fs-bin/...
🧬Ancestry DNA Kit click.linksynergy.com/fs-bin/...
🌳 Subscribe to Ancestry.com click.linksynergy.com/fs-bin/...
🌳 Gift Subscription to Ancestry click.linksynergy.com/fs-bin/...
🧬 Your DNA Guide Classes & Coaching www.yourdnaguide.com/ref/6/
👉 Legacy Tree Genealogists Coaching www.legacytree.com/genealogytv
🍂 MyHeritage Free Trial www.myheritage.com/complete-g...
Other Videos
🔴 Ancestry Updates September 2023
• Ancestry Updates Septe...
🔴 Dating & Identifying Old Photos with Photo Detective Maureen Taylor
• Dating & Identifying O...
🔴 Maximize Your Ancestry Research: 3 Secrets the Pros Use (Edited Webinar)
• Maximize Your Ancestry...
TIMING
0:00 Intro
0:15 Missing ancestor finally located
1:50 How do I know I found the right ancestor?
2:57 Tried multiple spellings and search criteria
3:39 Extract data from census and filter
4:55 How to extract from the entire census roll
5:18 Setting up excel worksheet for data extraction
6:42 How to extract after the first page
7:19 Tracking image numbers because it’s important later
8:26 Note - You need a later version of excel to do this!
9:23 How to freeze panes on worksheet
10:12 How to create filters
10:26 Searching with filters and still no results?
11:19 Filtering by age, gender & occupation
13:44 Should the transposed name be corrected?
14:30 Story behind why the ancestor is in another house.
15:36 Updating the research notes with source citation.
#Genealogy #GenealogyTV #FamilyHistory
Music Credits for Song on Word Tree Open
Circus Waltz Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
creativecommons.org/licenses/b...
@KGTiberius 10 ай бұрын
📍TIP: in standard search within Ancestry, you were using full names “Henry” or short names “Gus”. Try using the asterisk * as open parameter extension. G* or Gu* or Hen*. This asterisk can also work before, as well as both before and after (no spaces). * en * for all named that contain EN (Henry, Henly, Henley, etc.); or * us * returns Gus, Gustav, August, Gustavus, etc. - Asterisk is a very old school, hard code used almost everywhere. Asterisk is programming language built into nearly all systems. I had to put spaces in the above examples because asterisk is so heavily part of programming that it wouldn’t show in this message because it means something different in programming than the visual character itself.
@GenealogyTV 10 ай бұрын
Good point for the comment readers... I have used that trick many times. In this case, it was more about demonstrating the extraction and filtering using Excel. Thanks for sharing Kirk.
@sandyr1789 10 ай бұрын
Excellent point! When I have a surname variation I use this technique but you have to be sure to use the spaces: "surname / surname"
@chieffamilygenealogyoffice621 10 ай бұрын
I found in the NC digital archives a “William Hendley bible”. Is he in your family?
@johnlaws5231 10 ай бұрын
Thanks for 'How to find someone in a census, and how to use Excel for record extractions! I am researching 'LAWS' in the UK. My Gt-Gt-Gt Grandfather Henry Laws 1800-1880 a Master Mariner 7th child of 15 of John Laws Rope-maker of London gu-estimately 1741-1818 all a bit vague prior to Henry's marriage in 1825. been at this game 50 years collected a huge database of Laws worldwide to no avail
@soozieevans7222 9 ай бұрын
This will be very helpful for me. I still have my big brick wall that I have to work on breaking
@sioux9468 10 ай бұрын
Thank you for TWO lessons in one: How to find someone in a census, and how to use Excel for record extractions! I am grateful that you are willing to share your knowledge and experience. God bless you.
@GenealogyTV 10 ай бұрын
Thank you.
@familyhistoryenthusiast 4 ай бұрын
I needed a refresher in Excel. I haven't hardly used it since the 90s. I forgot all the cool little tricks you can do with it.
@AlannahRyane 10 ай бұрын
You are a genealogy tek genius presenter who draws us into the details effortlessly bravo!!!
@GenealogyTV 10 ай бұрын
Thanks
@martast.john-anders6448 10 ай бұрын
Great lesson! I have paged through many, many censuses but I never thought to extract the data that way. I disagree about making the correction and I'd love to hear what Ancestry has to say. I would have changed it and chosen as a reason INCORRECT IN IMAGE. You aren't actually changing the original transcription; you are adding an alternative search term. This means that other people who are searching for Gus will be able to find him even though the surname and given name were switched. Notice that the boy above him was also switched. I would have corrected his name as well.
@SparkeyCox 10 ай бұрын
I just made my own comment about this and agree with you. I amm interested in the answer as well. I understand that corrections are to make finding the person easier. --- thanks
@On3man 10 ай бұрын
You are absolutely correct. She is dead wrong (pardon the pun) in stating that changing the index changes the original record as she does at 16:03. A “correction” to any Ancestry index does not change the original record, it only changes the index. Neither the Ancestry digital image of the census record, nor its index is the original record. It is a digital copy and although it can be thought of as a primary source, it is only so because it includes the image. The original record is the original piece of paper from which the image was taken. Obviously, it will not be changed, since nobody is going to rush down to the National Archives with pen in hand, assuming the paper copies even exist any more. The index is simply a finding aid and has no effect whatsoever on the original record or on Ancestry’s digital copy of it. The idea that changing the finding aid to a set of records changes the original record is pure nonsense since the index is not the record source, the record is. When a “correction” is made it adds a new entry (record) to the index table which supplements the original entry. It does not replace it. In the example she uses, the original incorrect index record (Gustavus, Henly) would have remained and in addition there would now be an index record with the name entered correctly (Henly, Gustavus). In other words, there would now be two index records pointing to the same entry in the image of the census record. As you have rightly pointed out there is the “incorrect in image” choice in the "Why is this being added?” box along with a number of other choices and an option to provide a freehand explanation (sourced of course) for why you are making the change. In this case she could have added the information pointing to the other family entries in this collection and perhaps another source showing the family together. That way, when the next researcher comes along, they see find the individual, plus the information proving the relationship. Any “corrections” made to indexes (which, as any experienced genealogist will tell you, can be notoriously full of errors) makes it easier for the next person looking for that record. My own opinion is that not adding a correction to an index, when the ability to do so is there, is either a symptom of selfishness or ignorance of the difference between an index and its corresponding record, or how the addition really affects the index. (In this case, I believe, judging from her dialog, that it is the latter). However, I find it really disappointing that an obviously experienced KZfaqr genealogist with almost 100K subscribers would put our such a great tutorial and then ruins it with complete nonsense about indexes and records. I can only hope that she might re-record this video with the error corrected, and the index corrected. Otherwise I fear that there are probably more than few less experienced genealogists out there who will get the wrong idea that the index is somehow the record and should not be changed, which, of course, will make things harder for the rest of us who know better.
@martast.john-anders6448 10 ай бұрын
@@On3man That was really harsh. I don't appreciate your using my comment as a springboard to voice your criticism.
@On3man 10 ай бұрын
@@martast.john-anders6448 sorry you feel that way.
@dottiemoon8306 10 ай бұрын
This was Great Connie! Thank you. For those of us that are visual learners, the detailed step by step was perfect.
@GenealogyTV 10 ай бұрын
Awesome. Thanks for supporting the channel.
@loiscarson5526 10 ай бұрын
Maybe Gus was living with kin
@JPaulHawthorne 10 ай бұрын
Great tips on census researching! I just went to my missing people (in 1870 also) and after 4 hours, the mystery for one is still a mystery... But, I figured out two people were moving out of state at the time!
@GenealogyTV 10 ай бұрын
Interesting. I'm wondering if your mystery person followed them (those who moved out of state).
@jillbarger2593 10 ай бұрын
While you've addressed this topic in other videos I found this one most helpful. Taking your search beyond the name opened some ideas for me on finding one of my relatives who doesn't show up on the expected census. Thanks Connie!
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@GenealogyTV 10 ай бұрын
... and thanks for supporting the channel!
@kathleenkelley1299 10 ай бұрын
Love this! What a great find. Thanks for the refresher on extracting census data into Excel
@GenealogyTV 10 ай бұрын
My pleasure!
@pauletteweaver7049 10 ай бұрын
Can't wait to try this for one of my problem ancestors. Thanks!
@GenealogyTV 10 ай бұрын
Good luck. Thanks for supporting the channel.
@SalonBarbette 10 ай бұрын
Great reminder! You've inspired me to try this with some church records that I am compiling. Thanks for the clear and straightforward instructions. Much appreciated. 👍
@GenealogyTV 10 ай бұрын
Thank you and thank you for supporting the channel.
@faustbos 10 ай бұрын
Great vid, never thought of exporting to Excel (or manually exporting... ie copying). One thing, I also try searching with names reversed, Mistakes happen. I'm not sure I agree though about not fixing it. You're not destroying the original info, you are adding aliases, and there is actually a choice for incorrect in image. I do change these types of mistakes because there may be other researchers with less experience out there looking for the same record. What I do not add though, is nick names, or commonly used names, gritting my teeth here, like Nonno. One of my biggest pet peeves when I'm helping people is when they are looking for "Nonno something". Yes I'm very excited his your Nonno, but that helps exactly zero. Also, I only update the info when I'm certain of birth names. I might have even corrected the spelling of the last name as incorrect as well, or error in transcription if that was the case. I don't see a reason to keep bad meta data. Maybe you disagree? Would be interested in your reasoning. Regardless, great trick, too bad Ancestry doesn't make an extraction like this easier to do... one button. Thanks again!
@GenealogyTV 10 ай бұрын
Well Ancestry pays for those records and platform, so I kind of understand why they don't allow a lot of extraction. I'm kind of on the fence about whether that name should be edited in the index, but I hear you.
@garylhaas2005 10 ай бұрын
If you can see it on the screen, you can extract it. Excel VBA and Power Query AND Microsoft Power Automate Desktop can do magic.
@kareno8634 9 ай бұрын
@@GenealogyTV Hi, Nice Work! To me it takes quite a bit of patience, ideas, and organization, to point either Excitement or Anxiety takes over. Companies may have stocked their Database with our info, (thus charge) but no reason why We couldn't search from Government site, [either]. A matter of Public Record: re: "Pay" - I find it 'Odd' that Anyone should Have to Pay for Records OF the people. Our government has these records PAID for BY the people. _just a 'thought',_ - most likely correct. - Our governments, (and the BAR) have Usurped our Rights, Constitutions, and Laws, in effort to ConTrolled the people.^ Didn't mean to get all political 'karen'. lol The more *We Read and Learn, We Stand and Take back.* ^ We must Learn we have Unalienable Rights, and holding All political Power, and Use them. *Nice to see Gus was with his Dad,* any chance William went to his? (name switch too?).2:37 *Thanks* for your info, will pass it on. Cheers!
@sandyr1789 10 ай бұрын
Connie - Congratulations on breaking through a brick wall! Thank you for your thorough explanation and the way to be utilizing Excel to extract the information. Your explanation to use the newest version of Microsoft Excel was very important!
@sr2291 10 ай бұрын
That was really cool. Our elderly ancestor and his wife had moved to Texas and we lost track of one of his adult daughters. We found out through someone elses research that she was 4 pages ahead living with her husband. Her first name is unique so if I had done this I could have found her on my own. Thanks.
@grantfahlman1815 10 ай бұрын
That is some crazy sh**! A great example of how intensive, time-consuming, and in-depth the process can become when trying to dig through old records. Certainly also shows how dedication and persistence can be your best friends (and also why some people get a few extra wrinkles when trying to find "lost" records)!
@dwlee9138 10 ай бұрын
As an IT professional of 40 years and a genealogist for 31, that was EXCELLENT work! Kudos!
@GenealogyTV 10 ай бұрын
Wow, thank you!
@debbeb4499 10 ай бұрын
Congratulations, Connie! I can imagine your joy in the moment.
@lloydpenfold486 9 ай бұрын
I have been doing genealogy here in the UK for over a decade now, and also thought I was competent in Excel, but have learnt several new things in your short video. Thanks! I'll watch them all now!
@GenealogyTV 9 ай бұрын
We all learn from each other.
@richardhoover4471 10 ай бұрын
Great use of the Excel trick. I have used the extraction of census info into Excel several times since you first did a video on that. It even works for foreign censuses- like Norway censuses!
@GenealogyTV 10 ай бұрын
Oh good to know. Thanks for supporting the channel Richard.
@MrSlikvee 10 ай бұрын
Absolutely awesome! I could not find my own grandfather’s family for years! I finally gave up and unsubscribed from Ancestry because I was frustrated. Your work here has recharged me and I’m seriously considering going back at it. Evidently there are all kinds of tricks to use for these things! Also…another relative finally found my grampa. Just gave up too soon. Thank you!
@GenealogyTV 10 ай бұрын
Thanks for the compliments
@liannejohnson8193 10 ай бұрын
Awesome Connie. What a handy helpful tip and procedure. Thanks.
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@anellawrites 10 ай бұрын
This is why my dream career is time-traveling genealogist. I WANT to see the stories behind the data.
@GenealogyTV 10 ай бұрын
Me too!
@jilldowding-walker8066 10 ай бұрын
😂❤
@MKB0720 10 ай бұрын
WOW, what a wonderful method you have given us to use in our genealogy research!! Thank you so much for being willing to share your genealogy research knowledge.
@ShineKelly 10 ай бұрын
Loved this 'doing genealogy' trick /'hack' :) Also really appreciated seeing Excel used as the excellent tool it can be - it is the one programme I have always avoided using or learning to use. I guess I have a love hate relationship with it - I do wish I understood how to use it better! I am defo going to try this method even if it is just to consolidate those Excel user tips (I didn't know how to freeze panes - this will help me at work too!).
@carolinabasketeer8598 10 ай бұрын
I found him quickly by searching for occupation apprentice (exact), born 1862 in NC, lived in Randolph Co, NC (exact). He popped right up as Henly Gustavus.
@mspeedie52 10 ай бұрын
Great information. Just a shout out to you. I am a FamilySearch consultant and I told a new patron to our centre all about you and your KZfaq channel. She had now started following you. I love your videos.
@GenealogyTV 10 ай бұрын
Awesome! Thank you!
@katietisdall8207 10 ай бұрын
Simply Brilliant! I don’t know why I didn’t think of this myself. I have done searches page by page before but never thought to grab the transcribed data and put it into Excel to manipulate. Word of caution sometimes I’ve found people have been missed in the transcription. But wow this is a time saver. Thank you!
@amymaki2918 10 ай бұрын
Wow! Your navigation through the data extraction process is stellar! And you obviously have done this for some time. Thank you for sharing part of your journey and showing us how to drop history into Excel. This ancestress and her children definitely have a story waiting to be told!
@GenealogyTV 10 ай бұрын
LOL.. Yes they do.
@sandykling5893 10 ай бұрын
That was some serious digging!! I didn't realize we could extract census info, thanks for the great tip and thinking outside the box!
@ttschrock7126 10 ай бұрын
Wow. Very helpful and appreciated!! Thank you!!
@rondaparker7612 10 ай бұрын
What a wonderful video-tutorial. I did not know you could do all of that with Census and excel. I was so happy and excited for you when you found him!
@dinapreuss1922 10 ай бұрын
GAME CHANGER! Connie, thanks so much for this. I do have a version of Excel that allows me to do this. I'm so excited to try it out - I've got a couple of missing kids too!
@GenealogyTV 10 ай бұрын
You're so welcome!
@myfamilyhistorian 10 ай бұрын
DING DONG! How exciting. Your work paid off!
@kristitedrow1577 10 ай бұрын
Excellent tip. Thank you.😊
@TheBBBB0B 10 ай бұрын
Wow! My head is still spinning. Great work.
@donnas9599 10 ай бұрын
What a treasure trove of helpful information. Thanks SO much!!
@tammywilliams2035 10 ай бұрын
Thank you very much for showing how you searched for that. I’ve used your trick to download census records, but never thought to sort it by the age, gender, etc - or thought about maybe a transcription putting first name last :). Thanks for all your help.
@Chris-iz1rd 10 ай бұрын
Wonderful! It is a challenge to do what we do, but we keep going. Working angles and names variations and even trying them backward and forward!
@toniasalways 10 ай бұрын
It would be helpful to the next person looking for him to have it corrected on the census. Ancestry lists all the alternate names that have been given. I amend names wrongly indexed like this just to make life easier for the next person. Those wrongly indexed people create a terrible quagmire. I would have used "apprentice" as key word and searched from that. There would likely be very few apprentices.
@RandHall 10 ай бұрын
You beat me to it! I love the screen scraping and all, but once you know the magic word...just toss it in the Keyword field. THAT is an under appreciated trick. I love trawling censuses, directories, and phonebooks by street address in the keyword field.
@loganpuckett 10 ай бұрын
Wow, love your work. You are great.
@GenealogyTV 10 ай бұрын
Thank you! Cheers!
@annettecada4905 10 ай бұрын
That was awesome, I'll be using this!
@jeanp.1303 10 ай бұрын
Super helpful. Thanks!
@dchall8 9 ай бұрын
Really good use and demonstration of how to use the filter function. I practically made my career on knowing how to use filters when nobody in the organizations where I was knew about it. Even when I showed them how to do it, they came to me to find spurious information. So, yes! It is a secret out there in plain sight.
@cakebaker1967 10 ай бұрын
Brilliant! Thank you for sharing.
@GenealogyTV 10 ай бұрын
My pleasure!
@deborahcavel-greant6155 10 ай бұрын
Fantastic! What a great lesson! Thank you!
@GenealogyTV 10 ай бұрын
Glad you liked it!
@marshashoemake1246 9 ай бұрын
That was an awesome tip!! Thank you for always teaching us.
@GenealogyTV 9 ай бұрын
You are so welcome!
@anital5020 10 ай бұрын
Awesome!! You are so helpful!!
@GenealogyTV 10 ай бұрын
I try.
@debjordan4399 10 ай бұрын
Great information Connie!! Thank you for sharing.
@GenealogyTV 10 ай бұрын
Glad you enjoyed it.
@jostclair63 8 ай бұрын
Thank you for all of your helpful hints with Genealogy Research.
@GenealogyTV 8 ай бұрын
Glad you like them!
@deborahtanner354 10 ай бұрын
great lesson! great to hear your excitement!
@GenealogyTV 10 ай бұрын
Thanks Deborah and thanks for supporting the channel.
@lynntaylorbuccafuri5924 10 ай бұрын
Awesome!! Thank you, I would never have known this was possible.
@GenealogyTV 10 ай бұрын
Glad I could help!
@user-ed3db8fh2u 10 ай бұрын
Thank you for sharing! You are amazing at finding information.
@GenealogyTV 10 ай бұрын
You are so welcome!
@Rocadamis 10 ай бұрын
Great video. I'm glad you showed us the process of how you went through it. Following your other videos, I put some census records in Excel and it is miraculous how it can do these power searches. I have a bit of a brick wall with my grandmother and not finding her in a 1900 census. I tried this with her and couldn't find her, so the search goes on. However, it is a great technique.
@christinecarroll9364 10 ай бұрын
Best video on research that I've seen in a long time, thank you!
@GenealogyTV 10 ай бұрын
Wow, thanks!
@marcyd9625 10 ай бұрын
This is great! Thank you for sharing!
@GenealogyTV 10 ай бұрын
My pleasure.
@janettefowlds9744 10 ай бұрын
Thank you so much, Connie, I have learned a lot in just this one lesson. Thanks also for all the time and effort you put into bring us these videos, much appreciated.
@GenealogyTV 10 ай бұрын
You are so welcome! Thanks for supporting the channel.
@brendaashton6428 10 ай бұрын
I have a pair of brothers, missing from 1916 Western Canada Census and am using your method right now to try to find them!
@GenealogyTV 10 ай бұрын
Good luck!
@advancedloiterer1820 10 ай бұрын
I loved this video. Using MS Excel in this manner has so many applications in family history research, especially with establishing extended family units found in DNA results. My mind is bursting with ideas. Thank you for sharing.
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@evabrechtel4321 10 ай бұрын
Congratulations on your find! And thanks for the excel tip!
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@barbarah5756 10 ай бұрын
Score! Again!! You are amazing! Thanks for sharing, Connie.🥰
@GenealogyTV 10 ай бұрын
😊 thank you
@user-bs6yk6mb6l 10 ай бұрын
Thank you! Never knew we could download that data. This will help SO much 😊
@GenealogyTV 10 ай бұрын
Happy to help!
@heidihamilton1536 10 ай бұрын
Great job Connie! Awesome detective work!
@GenealogyTV 10 ай бұрын
Thank you!
@carlaporath7076 10 ай бұрын
OMG.....great find!!!! I have a similar story on my great-grandfather. The story goes when his mother remarried following the death of his father, the step-father did not like him. So, I have not been able to locate my great-grandfather. I need to use these tips ASAP!!! Thank you so much
@PragmaticPerson 10 ай бұрын
Fantastic! I will make a spreadsheet like that for the census in my challenging areas and save it. Maybe someday Ancestry will have that as a feature.
@kca3kids1 10 ай бұрын
This is life changing! Thank you so much. I’ll use this now regularly. My brain works like yours and I had hit that same searching barrier so many times after hours of image viewing! It’s wonderful to have this new tool to break through. Many thanks!
@GenealogyTV 10 ай бұрын
Glad you liked it.
@imp822 7 ай бұрын
Wow, that was cool! What great info! And I so appreciate your demo on copying and pasting into Excel!
@GenealogyTV 7 ай бұрын
Glad it was helpful!
@IowaKim 10 ай бұрын
Great use of the Excel spreadsheet, well done!
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@sherimc4869 10 ай бұрын
I ❤ your step-by-step to Excel!!! 💥🏆💥. Esp. that you show the steps more than once. Awesome tips! THANK YOU!
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@user-rn1hn3fg5y 9 ай бұрын
You are amazingly helpful. Thank you for both verbal and visual direction. Onward you go!!
@GenealogyTV 9 ай бұрын
Glad it was helpful! Thanks for the compliments.
@barbaraderber5222 10 ай бұрын
That was really interesting, thank you
@vicnurse5 10 ай бұрын
You are just amazing...thanks so much for all the information you give. Vicki in Australia
@GenealogyTV 10 ай бұрын
Thanks Vicki in Australia.
@loiscampbell3510 9 ай бұрын
Wonderful instructional video. Thanks so much!
@GenealogyTV 9 ай бұрын
Thanks
@marshabaker3044 10 ай бұрын
Amazing lesson. Ive tried doing something similar with excell but didn't know eniugh about it to do it properly. Thankyou.
@user-tm1bw4wl3o 10 ай бұрын
Genius!!! Thanks, Connie.
@GenealogyTV 10 ай бұрын
Thanks.
@martiphone4884 10 ай бұрын
WOW! Wonderful tip and great detective work on your part. What fascinating family and the untold stories.
@GenealogyTV 10 ай бұрын
Thank you!
@queserasera1540 9 ай бұрын
What a great way to find missing family members. So much easier than going through every listing in a census. I can't tell you how many times I've reviewed complete censuses trying to locate those elusive people!
@GenealogyTV 9 ай бұрын
Agreed. When I started out (before computers, that dates me) I had to scroll for hours through microfilm reading each line until my head was spinning... hoping I didn't skim over the one person I really needed. Thank God for indexers and computers! :) Research is so much faster now.
@heloshark 9 ай бұрын
Very impressive work and production quality.
@GenealogyTV 9 ай бұрын
Much appreciated!
@CocoAmanda 7 ай бұрын
This information is absolutely vital. I can’t wait to do it myself. thank you 😁🙏
@GenealogyTV 7 ай бұрын
Glad it was helpful!
@carolynmckee4295 9 ай бұрын
Wow! Fascinating!
@jackiemedeiros8019 10 ай бұрын
That was amazing. Thank you so much.
@GenealogyTV 10 ай бұрын
You are so welcome!
@kimberlypierce3178 10 ай бұрын
This is GREAT information!! I've been trying to locate my great grandmother using 1910 - 1950 census and haven't had any luck. Hopefully now, I can find her!!
@meganwallace3344 10 ай бұрын
Woah, this was amazing info! Thanks a ton! My Great Grandmother is a Henley and it has been nearly impossible to find information on her. Everything that was ever told to us growing up was in secret so to speak lol You have gained a new follower in me! I look forward to more research tips!
@GenealogyTV 10 ай бұрын
Glad you enjoyed it!
@deetrvl4life875 10 ай бұрын
Wow! I just HAD to subscribe! I've always had an interest in this, but you're an amazing teacher too! A great lesson in Excel AND how to in Geneology tracking. Thank you! 😊
@GenealogyTV 10 ай бұрын
Wow, thank you!
@TheRIGHTTreeGenealogy 10 ай бұрын
Connie, another solid video. This method did not find my 1850 missing ancestor... BUT did allow me to find Transcription Errors that I have corrected. I do follow the Transcription Protocol (only trascribing as seen not assumed). Thanks again for this video.
@amelias.2509 9 ай бұрын
Wow! Just came across your channel and just subscribed. You are so compelling. In a few short minutes you've revived my interest in my genealogy search. Looking forward to a fun winter project with you. ❤
@GenealogyTV 9 ай бұрын
Awesome! Thank you!
@DaveWhitehouse 10 ай бұрын
Wow, amazing work.
@familyhistoryenthusiast 4 ай бұрын
You are the best teacher! Bless your heart. You're my favorite genealogy KZfaqr.
@GenealogyTV 4 ай бұрын
Ah thanks
@JayEmree 10 ай бұрын
Thank you for this. I've just bookmarked your GoogleSheets video to attempt this one of these days. I have family missing in the 1920 census I'd like to find.
@christopherfairs9095 10 ай бұрын
A very useful tactic for finding lost people in a census. Thank you.
@GenealogyTV 10 ай бұрын
You're welcome
@TheZeebop2007 10 ай бұрын
Brilliant! I can’t wait to try this. Thank you so much 😊
@GenealogyTV 10 ай бұрын
Hope you enjoy it!
@TheZeebop2007 10 ай бұрын
@@GenealogyTV It is so useful. Thank you again!
@suzanneleopard430 10 ай бұрын
I saw you do this before with the 10 pages before the census and 10 pages after, but this is totally awesome! Thank you for sharing! Can't wait too try this!
@GenealogyTV 10 ай бұрын
Awesome! Thank you!
@user-cc5bw4lf2n 10 ай бұрын
Absolutely brilliant!
@GenealogyTV 10 ай бұрын
Why thank you!
@lindahill7315 10 ай бұрын
That helps alot. Thank you
@janinebell4336 10 ай бұрын
Thank you! I have copied and pastred special into Excel before BUT I didn't know how to do more detailed filters that you explained. GOLD!
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@cathytitlow7804 10 ай бұрын
I don't know how often I will use this tip, but this was one of the best tips I've seen. I went to Excel and practiced and I can definitely see how useful this would be. Thanks, Connie.
@GenealogyTV 10 ай бұрын
Glad it was helpful!
@alvree01 10 ай бұрын
Thank you for very helpful information on extraction. Hope it helps me in some of my brick walls
@GenealogyTV 10 ай бұрын
Best of luck!
@brendaphillips1430 5 күн бұрын
Thank you for sharing, I hope this trick works for me on a similar problem!
@LeAllysonMeyer 10 ай бұрын
Fantastic research!
@GenealogyTV 10 ай бұрын
Thank you!
@davidmayer2082 10 ай бұрын
What a fabulous application of your extraction technique! Genealogy magic -- 'cept there's no magic it's all your smarts and determination!!
@GenealogyTV 10 ай бұрын
LOL... yeah... I'm a magician. :)
@donnacrimmins789 10 ай бұрын
Wonderful work!
@GenealogyTV 10 ай бұрын
Glad you like it!
@exdus235 10 ай бұрын
OMG! Can't wait to try this. I too have relatives who were farmed out around 1870, in Illinois. Trying to discover why. This video is a godsend. TYVM TYTYTYTY. ❤️
@GenealogyTV 10 ай бұрын
OMG... I can't wait for you to try it too! LOL. You're welcome several times over.
Genealogy TV
Рет қаралды 52 М.
Family History Fanatics
Рет қаралды 13 М.
Genealogy TV
Рет қаралды 29 М.