Excel Forum
Similar Content
Custom Delete Rows in Excel
Tutorial: How to custom delete multiple rows at once in Excel. This allows you to check for as many...
Filter While Leaving Original Data Intact in Excel
Tutorial: How to filter in Excel by copying the filtered data to a new location without doing anyth...
Introduction to Using Filters to Refine Data in Excel
Tutorial: Filtering allows you to hide rows of data which you are not interested in so that you can ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick #211: Advanced Filter Extract ID Variable


See how to extract records from an Excel Database / List / Table when the first 7 ID digits are the same but the last few are variable. We will use a True / False formula in a new column and Advanced Filter. Data Analysis Trick.
See the LEFT and LEN functions.
See how to convert numbers to text with an ampersand and the symbol for blank (double quotes).
See how to create an Excel Table List with a keyboard shortcut.





Got a Question? Ask it Here in the Forum.