Est. Budget: $10.00
I have a spreadsheet like this:
Data - this is the source data (often up to 500,000 rows and 100 columns)
Locations - these are the locations upon which I want to filter the Data sheet
Filtered Data - that's filtered data. only rows from Data where Data!B:B matches at least one of the cells in Locations!A:A
this should be done using standard formula only (excel or ...