Excel - Elections Board Dates 20131017 - Episode 1809
714 views · Published 17 October 2013 · 2:45 · Indexed 6 November 2026
Channel: MrExcel.com · 2013 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920