Excel - Elections Board Dates 20131017 - Episode 1809

714 views · Published 17 October 2013 · 2:45 · Indexed 6 November 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Filtering Board of Election Data in Year-Month-Day Format.

Welcome back to the MrExcel podcast. In this episode, we will be discussing how to filter Board of Election data in a year-month-day format. This is a common issue faced by many Excel users, and we will show you how to solve it in a few simple steps.

Recently, I had the pleasure of conducting a power Excel seminar in Fort Myers, Florida. One of the attendees, Chris, brought up an interesting problem he was facing. He had a data set from the Board of Elections with 400,000 voter names, but the date of birth information was in a single string format. This meant that the date was represented as 8 digits, with a 4-digit year, 2-digit month, and 2-digit day. Chris needed to filter this data to find all the people born in a certain age range, such as the 1950s, for a mailing campaign.

Luckily, Excel has a solution for this. In this video, we will show you how to convert the date string into a real date format using the Text to Columns feature. This will allow you to use all the date functions and filters in Excel to easily extract the data you need. We will also show you a handy trick to quickly filter the data by a specific date range using the Date filters in Excel 2010.

To start, we will select the data and use the Text to Columns feature to convert the date string into a real date format. Then, we will use the Date filters to select the desired date range, in this case, the 1950s. We will also show you how to copy the filtered data to a new worksheet for further analysis. This simple solution will save you time and effort when working with large datasets.

I want to thank Chris for bringing up this great question during my seminar, and I hope this video helps all of you facing a similar issue. Don't forget to subscribe to our channel for more Excel tips and tricks, and leave a comment below if you have any questions or suggestions for future videos. Thank you for watching, and I'll see you in the next MrExcel netcast.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
 
(00:00) Episode Topic: Filtering Data in Year-Month-Day Format 
(00:10) Scenario: Board of Election Data 
(00:20) Audience Member's Question 
(00:42) Solution: Converting Dates and Using Filters 
(01:03) Step-by-Step Instructions 
(02:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Converting data to real dates
Copying data to a new worksheet
Data set from the Board of Elections
Excel seminar
Filter Board of Election Data
Getting people of a certain age
Single string date of birth information
Tricks for handling dates in 8-digit format
Using date filters in Excel 2010
Year-month-day format

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153630/



Chris has 400K records from the Board of Elections. The date of birth field is a string of 8 digits in YYYYMMDD format. Today's episode shows how to convert that number to a useful date and then how to apply a filter to copy everyone born in a certain decade.

More from this channel