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 numbers). In the table, the same criterium (i.e file numbers) may apply to several rows.
Thank you
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
