Uploaded September 2023 | Updated September 2026, 1 week ago
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-genealogy-tv-academy
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. youtube.com/@genealogytv/join.
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at youtube.com/@GenealogyTV/community
📝 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. patreon.com/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!
youtube.com/@genealogytv/join
❤️ Patreon Membership – Handouts Emailed as they are produced. patreon.com/GenealogyTV.
✅ Genealogy TV WEBSITE
genealogytv.org
✅ GTV on FACEBOOK
facebook.com/Genealogytv
✅ SIGN UP For GTV’s NEWSLETTER
https://mailchi.mp/a0862c6473aa/genealogytvnewsletter
👉 Subscribe to Genealogy TV (Free)
youtube.com/channel/UCcvpi8XvOScBogIxmarmADw/Subscribe
*** GTV Affiliate Partners ***
🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites.
amazon.com/shop/genealogytv
🌳 FREE TRIAL to ANCESTRY.com click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.3&type=3&subid=0
🧬Ancestry DNA Kit click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.2&type=3&subid=0
🌳 Subscribe to Ancestry.com click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.3&type=3&subid=0
🌳 Gift Subscription to Ancestry click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.9&type=3&subid=0
🧬 Your DNA Guide Classes & Coaching yourdnaguide.com/ref/6
👉 Legacy Tree Genealogists Coaching legacytree.com/genealogytv
🍂 MyHeritage Free Trial myheritage.com/complete-genealogy-package?keyword=partners&utm_source=partner_genealogytv&utm_medium=partner&utm_campaign=genealogytv_march20&tr_funnel=Complete
Other Videos
🔴 Ancestry Updates September 2023
youtu.be/no-uyOkSVLw
🔴 Dating & Identifying Old Photos with Photo Detective Maureen Taylor
youtu.be/ZCxSljUTO1Y
🔴 Maximize Your Ancestry Research: 3 Secrets the Pros Use (Edited Webinar)
youtu.be/4GLM9Z7jTAE
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/by/3.0
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-genealogy-tv-academy
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. youtube.com/@genealogytv/join.
As a Channel Member, find the handouts by scrolling through the blog posts on the Community tab at youtube.com/@GenealogyTV/community
📝 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. patreon.com/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!
youtube.com/@genealogytv/join
❤️ Patreon Membership – Handouts Emailed as they are produced. patreon.com/GenealogyTV.
✅ Genealogy TV WEBSITE
genealogytv.org
✅ GTV on FACEBOOK
facebook.com/Genealogytv
✅ SIGN UP For GTV’s NEWSLETTER
https://mailchi.mp/a0862c6473aa/genealogytvnewsletter
👉 Subscribe to Genealogy TV (Free)
youtube.com/channel/UCcvpi8XvOScBogIxmarmADw/Subscribe
*** GTV Affiliate Partners ***
🛍️ Genealogy TV’s AMAZON STORE full of Connie’s favorites.
amazon.com/shop/genealogytv
🌳 FREE TRIAL to ANCESTRY.com click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.3&type=3&subid=0
🧬Ancestry DNA Kit click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.2&type=3&subid=0
🌳 Subscribe to Ancestry.com click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.3&type=3&subid=0
🌳 Gift Subscription to Ancestry click.linksynergy.com/fs-bin/click?id=h02/ybBif9I&offerid=1347376.9&type=3&subid=0
🧬 Your DNA Guide Classes & Coaching yourdnaguide.com/ref/6
👉 Legacy Tree Genealogists Coaching legacytree.com/genealogytv
🍂 MyHeritage Free Trial myheritage.com/complete-genealogy-package?keyword=partners&utm_source=partner_genealogytv&utm_medium=partner&utm_campaign=genealogytv_march20&tr_funnel=Complete
Other Videos
🔴 Ancestry Updates September 2023
youtu.be/no-uyOkSVLw
🔴 Dating & Identifying Old Photos with Photo Detective Maureen Taylor
youtu.be/ZCxSljUTO1Y
🔴 Maximize Your Ancestry Research: 3 Secrets the Pros Use (Edited Webinar)
youtu.be/4GLM9Z7jTAE
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/by/3.0
