Forum Discussion
Filter function with multiple tables/arrays
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))
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.
Hi,
I can select all columns or 1 column with filter. How do you return 2 columns?
Thanks!
Sorry for raising questions with my question, it was never my intention. I'm just learning. 😄 Maybe my explanations are not the best either as English is not my first language.
Formula I did was based on this video: https://youtu.be/KG7Ih_Yf-fg?si=0_hGry7OrZTETto_
I specified each column since I understood FILTER function would retrieve all columns (as you said) but would do so based on results based on single column, so specifying multiple allows to search for matches in any of them.The IFNUMNBER helps doing partial matches, perhaps this can be done easier too, but the approach I used is described at 04:30 mark in the video linked.
I will see if I can prep some sample file, but it might be too time consuming, I'm afraid.
As per my reply to HansVogelaar above, I am getting there, but now ran into some other error.Thanks.
