Forum Discussion
How to select rows in a table corresponding to criteria that apply to several rows?
Hello, I'm trying to select rows in a table according to criteria that appear in the first column of the table. The selection criterion is to correspond to a list (for example: a list of file number...
You don't say WHERE you want to do this. If in a filter applied to a table, choose perhaps "Text filter" in the drop down and knock yourself out.
If you wanted to do so in a SPILL formula, try perhaps
=FILTER(ROW(myTable), IFNA(MATCH(INDEX(myTable,0,1),myCriteria,0),FALSE))
to receive the matching row numbers.
Thank you for your answer.
I wanted to create a different table for the selected data.
I am going to try your suggestion. Could you please explain me what you mean with SPILL formula ?
Thank you again,
Françoise