does not match something in the rows google sheets code example

Example 1: match cell with the value google sheets

=MATCH("Sunday", A2:A9, 0)

Example 2: google sheets filter rows above current cell

-- Google Sheets: Filter rows above current cell
=filter(
  indirect("R2C3:R" & row()-1 & "C3", false),
  indirect("R2C3:R" & row()-1 & "C3", false) = "Search Word"
)
  
-- Note: Use must use R1C1 notation, not the A1 notation

Tags:

Go Example

Related