Forum Discussion
Filtering one column using the values of another one
I have a main list of products from my shop that I need to filter based on a numerical code, and I have the codes I need to filter in a separate column, how do I filter the main list to only show the numbers that match with that second list I have?
As an example so it can be a bit clearer,
Let's say I have a list of products ranging from 1-10 , and I have a secondary list of X numbers (that can be inbetween 1-10 or not), how do I filter the first list to see if any of them matches with that second list?
1 Reply
=FILTER(A2:A11,COUNTIF(C2:C9,A2:A11))If you work with Office365 or 2021 you can try above formula.
If you don't work with Office365 or 2021 maybe the attached xlsm. file is helpful. Enter your secondary list in range C2:C13 and click the button in cell I2 to start the macro.
