Forum Discussion

Copper Contributor

Jan 05, 2024

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

excel

Formulas and Functions

HansVogelaar
Jan 05, 2024
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))

mathetes

Silver Contributor

Jan 05, 2024

greinholds Your question raises lots of questions of its own. For one thing, the FILTER function is capable of retrieving all columns in a table (or selection of them) without needing to specify each, especially if they're contiguous columns in the source table. I wonder what purpose the ISNUMBER function is serving.

Would it be possible for you to post a sample copy of the workbook in question--all real customer names and any other confidential info being replaced with fictitious data--so we can take a look at it? Post on OneDrive or GoogleDrive, with a link pasted here that grants access to it.

RYoung

Copper Contributor

Dec 14, 2024

Hi,

I can select all columns or 1 column with filter. How do you return 2 columns?

Thanks!