Table of Contents
Excel is a powerful tool that allows users to organize and analyze large sets of data. One useful feature of Excel is the ability to filter data based on specific criteria. This allows users to quickly extract and view only the information that is relevant to their needs. To filter a column by multiple values in Excel, users can use the “Filter” function and select the desired values to be displayed. This feature is particularly useful when working with large datasets, as it helps to narrow down the information and make it easier to analyze. By using Excel’s filtering capabilities, users can efficiently sort and manipulate their data to meet their specific needs.
Excel: Filter a Column by Multiple Values
Often you may want to filter a column by multiple values in Excel.
Fortunately this is easy to do using the Advanced Filter function.
The following example shows how to use this function in practice.
Example: Filter Column by Multiple Values in Excel
Suppose we have the following dataset that contains information about various basketball players:
Now suppose we’d like to filter the dataset to only show rows where the Team column contains Heat or Celtics.
To do so, we can create a column that specifies which teams we’d like to filter for:
Then, click the Data tab along the top ribbon and then click the Advanced button within the Sort & Filter group:
In the new window that appears, use A1:C16 as the List range and E1:E3 as the Criteria range:
Once you click OK, the data will automatically be filtered to only show rows where the team name is equal to Heat or Celtics:
In this particular example, we chose to filter the data in-place.
If you’d like the filtered data to appear in a different location, simply check the button next to Copy to another location within the Advanced Filter window.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Cite this article
stats writer (2024). How do I use Excel to filter a column by multiple values?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-excel-to-filter-a-column-by-multiple-values/
stats writer. "How do I use Excel to filter a column by multiple values?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-excel-to-filter-a-column-by-multiple-values/.
stats writer. "How do I use Excel to filter a column by multiple values?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-excel-to-filter-a-column-by-multiple-values/.
stats writer (2024) 'How do I use Excel to filter a column by multiple values?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-excel-to-filter-a-column-by-multiple-values/.
[1] stats writer, "How do I use Excel to filter a column by multiple values?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use Excel to filter a column by multiple values?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.