Add to resources: Google Sheets 'filter/search' for partial text match
Opened this issue · 0 comments
genfhk commented
example, to create a filter to search for the term 'invalid' in column 'A', where column A has a header in cell A1 (partial match, so it will find any cell with this word):
=filter(A2:A,search("invalid",A2:A))