Secret Trick for Searching Genealogy Records on Ancestry

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 https://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. https://www.youtube.com/@genealogytv/.... As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at https://www.youtube.com/@GenealogyTV/... 📝 2) All handouts can be PURCHASED INDIVIDUALLY ($5 and up) at https://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! https://www.youtube.com/@genealogytv/... ❤️ Patreon Membership – Handouts Emailed as they are produced.   / genealogytv  . ✅ Genealogy TV WEBSITE https://genealogytv.org/ ✅ GTV on FACEBOOK   / genealogytv   ✅ SIGN UP For GTV’s NEWSLETTER https://mailchi.mp/a0862c6473aa/genea... 👉 Subscribe to Genealogy TV (Free)    / @genealogytv   ** GTV Affiliate Partners ** 🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites. https://www.amazon.com/shop/genealogytv 🌳 FREE TRIAL to ANCESTRY.com https://click.linksynergy.com/fs-bin/... 🧬Ancestry DNA Kit https://click.linksynergy.com/fs-bin/... 🌳 Subscribe to Ancestry.com https://click.linksynergy.com/fs-bin/... 🌳 Gift Subscription to Ancestry https://click.linksynergy.com/fs-bin/... 🧬 Your DNA Guide Classes & Coaching https://www.yourdnaguide.com/ref/6/ 👉 Legacy Tree Genealogists Coaching https://www.legacytree.com/genealogytv 🍂 MyHeritage Free Trial https://www.myheritage.com/complete-g... Other Videos 🔴 Ancestry Updates September 2023    • Ancestry Updates September 2023   🔴 Dating & Identifying Old Photos with Photo Detective Maureen Taylor    • Dating & Identifying Old Photos with Photo...   🔴 Maximize Your Ancestry Research: 3 Secrets the Pros Use (Edited Webinar)    • Maximize Your Ancestry Research: 3 Secrets...   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 http://creativecommons.org/licenses/b...