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))
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.