Excel Forum



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.