How to add multiple 'add current selection to filter' in excel?

Question

I have a large set of data with 20 columns. I am trying to filter out 49 different material numbers. The material number being one of the columns; Is there a way to add all of those numbers to the selection without typing them one by one?

I have tried using the advanced filter option, but it is not working for me. It returns all the fields and columns without filtering. I know for a fact that all of those material numbers are not included.

Answer 1

You may try formula.

=FILTER(A2:T25189,COUNTIF(V2:V51,C2:C25189)>0)

Answer 2

Could you share us your advanced filter settings?

Here is my test. You may use "filter the list, in-place."

1. List range: choose all the columns.
2. Criteria range, Header of your column and the 49 different material numbers under header.

Answer 3

I want to filter column C with the values in column V

Answer 4

Have you got the correct result? If not, we may use other function to get it.

Answer 5

I have not.