Excel Forum
Similar Content
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 Formula to Get Domain Name from a URL
Tutorial: Two formulas that you can use to extract the domain name from a URL or to extract the sub-...

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.