Table of Contents
Filtering multiple columns in Excel allows you to narrow down your data and view only the desired information. This can be done by selecting specific criteria to filter by, such as values, dates, or text. To filter multiple columns, you can use the “Filter” function located in the “Data” tab. This will create drop-down menus for each column, where you can select the criteria to filter by. For example, if you have a table with sales data for different products in different regions, you can use the filter function to only view sales for a specific product in a specific region. This can be helpful in analyzing data and making decisions based on specific criteria.
Filter Multiple Columns in Excel (With Example)
The easiest way to filter multiple columns in Excel is to use the Advanced Filter function.
The following examples show how to use this function in two different scenarios:
- Filter for rows that meet multiple conditions
- Filter for rows that meet one of multiple conditions
Example 1: Filter for Rows that Meet Multiple Conditions
Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:
Now suppose we’d like to filter for rows where the Region is Eastand the Product is A.
To do so, we can define the following range of cells that contains our criteria:
Next, we can click the Data tab and then click the Advanced Filter button:
We’ll choose A1:C17 as the list range and F1:G2 as the criteria range:
Once we click OK, the dataset will be filtered to only show rows where the Region is Eastand the Product is A:
Example 2: Filter for Rows that Meet One of Multiple Conditions
Suppose we have the following dataset that shows the total sales of certain products in certain regions for a company:
Now suppose we’d like to filter for rows where the Region is East or the Product is A.
To do so, we can define the following range of cells that contains our criteria:
Next, we can click the Data tab and then click the Advanced Filter button.
We’ll choose A1:C17 as the list range and F1:G3 as the criteria range:
Once we click OK, the dataset will be filtered to only show rows where the Region is East or the Product is A:
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How can I filter multiple columns in Excel, and what is an example of how to do so?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-filter-multiple-columns-in-excel-and-what-is-an-example-of-how-to-do-so/
stats writer. "How can I filter multiple columns in Excel, and what is an example of how to do so?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-filter-multiple-columns-in-excel-and-what-is-an-example-of-how-to-do-so/.
stats writer. "How can I filter multiple columns in Excel, and what is an example of how to do so?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-filter-multiple-columns-in-excel-and-what-is-an-example-of-how-to-do-so/.
stats writer (2024) 'How can I filter multiple columns in Excel, and what is an example of how to do so?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-filter-multiple-columns-in-excel-and-what-is-an-example-of-how-to-do-so/.
[1] stats writer, "How can I filter multiple columns in Excel, and what is an example of how to do so?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I filter multiple columns in Excel, and what is an example of how to do so?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.