This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You may try formula.
=FILTER(A2:T25189,COUNTIF(V2:V51,C2:C25189)>0)
This worked, thank you soo much!!!
You are welcome:)