Original Dataįilter multiple values from one column with the Advanced Filter functionįilter multiple values from one column with a helper columnįilter multiple values from one column and save the filter criteria for future using
In this article, I will talk about some quick ways for solving this job. To check the items one by one into the long Filter list box may not be the best way for filtering. It is easy for us to filter a specific value in a column with the Filter function in Excel, but, sometimes, you may need to filter multiple values from a long column as below screenshot shown. How to filter multiple values in only one column in Excel?
