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 c...
HansVogelaar
Feb 24, 2025MVP
=FILTER(wb1_range, COUNTIF(wb2_cities, wb1_cities), "")