Forum Discussion
Solved
Filter function with multiple tables/arrays
I have a sheet with data in it (customers contacts in this example, where columns contain name, surname, company and email) and with the following formula I can use a cell (F1) to enter search criter...
If you have Microsoft 365, you can use VSTACK to combine the results of three FILTER formulas
=VSTACK(FILTER(data on Customer batch 1), FILTER(data on Customer batch 2), FILTER(data on Customer batch 3))
What can i use if i have more that 3 sets of data to filter?
You can add more FILTER functions to the VSTACK formula.