excel mac 2011 filter search for more than one word

If you have assigned the list or Excel Table a range name, enter the range name.

As a consultant or analyst looking through data for answers you are going to need how to filter.

With the advanced filter in Excel you can filter and extract data using complex AND and OR criteria impossible with AutoFilter.

The Excel advanced filter can also extract filtered data into columnar reports.

You can turn the AutoFilter arrows off in an Excel Table when you need to.

If the list has filled cells touching the list border, then select the list headers and all data cells.

In this figure, the Region column contains text data, so only Text Filters are available in a side menu.

The types of filters available are Number, Text, Date, and Color.

The conditional criteria, such as Equals, Contains, etc., change to match the type of filter.

The AutoFilters in all columns must be TRUE for data to display.

Select checkboxes of the data you want to be displayed and clear checkboxes of data you want filtered.

Although Excel calls this the Top 10 AutoFilter, it does much more.

Selecting many of the AutoFilter menu items will display the Custom AutoFilter dialog box with the appropriate conditions preselected to match your menu selection.

For example, to find cut but exclude instances that also contain Lite, click And, and select Does Not Contain, and type Lite.

If the column contains text, other than the header, the filter will not work.

Select start and end dates for the range by clicking the calendar icons at the right and selecting start and end dates.

You can use wildcards as substitutes for an individual character or string of characters in text filters.

They contain buttons that display a list of unique contents for the column you want as a filter.

Click one of the buttons and the list or Excel Table is filtered.

With the Excel Advanced Filter you can create very complex filters as well as extract filtered data into a new list.

This figure shows the list or Table on the left, a Criteria range in green, and the optional Extract range on the right.

For example, RegionWest OR RegionEast requires two rows with one Region header label.

Excel Mac 2011 Filter Search For More Than One Word