Forum Discussion
omar keshek
Feb 28, 2018Copper Contributor
Filter multiple values equals to another list of values
I faced this problems many times and I am not able to find a solution. It happens that I need to filter a table, selecting only the values equals to the values of a column of another table. How can I...
SergeiBaklan
Feb 28, 2018Diamond Contributor
Hi,
As variant Advance Filter https://support.office.com/en-us/article/filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b?NS=EXCEL&Version=16&SysLcid=1033&UiLcid=1033&AppVer=ZXL160&HelpId=21102&ui=en-US&rs=en-US&ad=US could work if first table is not filtered.