How do you filter a column with multiple values

Question

I am trying to order the material. The approved material is in a spreadsheet with over 3600 material ID numbers. and I have 15 numbers I need to filter out. How do I filter the column by those 15 values rather than doing it one by one.

Answer 1

Hi,

In cell F2, enter this formula

=FILTER(A2:B6,ISNUMBER(XMATCH(A2:A6,D2:D4)))

Hope this helps.

Answer 2

Dear Justin Marquart,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

We are sorry to hear that you’re having trouble with filtering a column with multiple values. I deeply understand the inconvenience caused and apologize for it.

Could you please try the below steps:

1. Ensure your data is in a table format with headers.
2. Create a separate column or range where you list the 15 material ID numbers you want to filter by.
3. Go to the Data tab on the Ribbon.
4. Click on Advanced in the Sort & Filter group.
5. In the Advanced Filter dialog box, choose Filter the list, in-place.
6. Set the List range to your data range. Select your entire 3600 material data
7. Set the Criteria range to the range where you listed the 15 material ID numbers.
8. Click OK. Excel will filter the data rows.

We appreciate your understanding that sometimes the initial response may not resolve the problem immediately. However, we can work together to narrow down and resolve the situation. So, please let me know if you have any further questions or if there are any misunderstandings.

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator