Pinterest Pixel

Filter by Labels – Numerical Text

Pivot Tables do not just aggregate data, but also offer a lot of filtering options. One of... read more

Download Excel Workbook
Bryan
Posted on

Overview

Filter by Labels - Numerical Text | MyExcelOnline Filter by Labels - Numerical Text | MyExcelOnline

Pivot Tables do not just aggregate data, but also offer a lot of filtering options. One of these is filtering based on a column of numerical text.

You will be surprised that filtering works with numerical and alphabetical sequences. I will show you quickly the different filter by labels options and it is very straightforward to use!

 

Exercise Workbook:

download excel workbookFilter-by-Labels-Numerical-Text.xlsx


This is our current Pivot Table setup. We will be filtering the ITEM NUMBERS alphanumeric values. They come in the format of 3 numbers followed by 3 letters (e.g. 123ABC):

Filter by Labels - Text

STEP 1: Click on the Row Label filter button in the Pivot Table.

Filter by Labels - Numerical Text

STEP 2: Select Label Filters.

You will see that we have a lot of filtering options. Let us try out – Greater Than Or Equal To

Filter by Labels - Text

STEP 3: Type in 110aaa to get the values 110aaa and below when sorted alphabetically. You can see that the Label Filter will be applied to the ITEM NUMBERS.

See also  Maximum in Excel Pivot Tables

Click OK.

Filter by Labels - Text

Now we have the filtering applied in a flash!

You can see the values 110ZZZ, 120AAA, 139DDD are there as they are greater than or equal to 110AAA. It is impressive that filtering can be done to the alphanumeric text.

Filter by Labels - Text

 

You can also use Pivot Table to filter Top/Bottom items by value or percentage, etc, filter greater than or less than values, etc. Click here to learn all about Pivot Tables.

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Filter by Labels - Numerical Text | MyExcelOnline Filter by Labels - Numerical Text | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...