Forum Discussion
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 do it?
To be clear I have 2 tables:
1st table: only 1 column with the values I need to select (for example an ID list)
2nd table: several columns, one of these column is the one I need to use for the filter (for example an ID list).
I want to select in the table 2 only the lines where the ID values are the same on the ones of the table 1 (in ACCESS IT IS A JOIN). Can you help me?
Many thanks!!
Omar,
omar keshek wrote:
I want to select in the table 2 only the lines where the ID values are the same on the ones of the table 1 (in ACCESS IT IS A JOIN).
try Power Query. PQ features joins.
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.
