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...
=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.