Excel Forum
Similar Content
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 ...
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...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....

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.