Forum Discussion
Palvendor
Microsoft
Feb 24, 2025Filtering using other workbook's values
I have 2 workbooks (wb). wb1 has all records with many columns, 'city' is one of them. It includes all cities from US. wb2 has Washington cities. I want to filter city column of wb1 upon Washington cities. Means remove all records which are NOT Washington state cities. How can I do this? Please help.
1 Reply
Sort By
=FILTER(wb1_range, COUNTIF(wb2_cities, wb1_cities), "")