Pinterest Pixel

Filter by Labels – 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 Values - Between

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 text. I will show you quickly the different options of the filter by labels – text and it is very straightforward to use!

 

Exercise Workbook:

download excel workbookFilter-by-Labels-Text.xlsx


This is our current Pivot Table setup. We will be filtering the Sales Month text values.

Filter by Labels - Text

 

Example 1: Ends with

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

Filter by Labels - Text

STEP 2: Select Label Filters.

You will see that we have a lot of filtering options. Let us try out – Ends With

Filter by Labels - Text

STEP 3: Type in ber to get the months ending in ber. You can see that the Label Filter will be applied to the SALES MONTH.

Click OK

Filter by Labels - Text

Now we have the filtering applied in a flash!

Filter by Labels - Text

Similarly, we can use the “Does not End with” option to filter all months that do not end with ber.

See also  Move an Excel Pivot Table

Filter by Labels - Text

The filtered data will look like this:

Filter by Labels - Text

 

 

Example 2: Begins with

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

Filter by Labels - Text

STEP 2: Select Label Filters.

You will see that we have a lot of filtering options. Let us try out – Begins With

Filter by Labels - Text

STEP 3: Type in J to get the months starting with J. You can see that the Label Filter will be applied to the SALES MONTH.

Click OK

Filter by Labels - Text

This is what the filtered Pivot Table will look like:

Filter by Labels - Text

 

Similarly, we can use the “Does not Begin with” option to filter all months that do not begin with J.

Filter by Labels - Text

The filtered data will look like this:

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  Excel Pivot Cache Explained
Filter by Labels - Text | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

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!